sp help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

sp help

Author

Topic

densma
Starting Member

21 Posts

Posted - 2004-06-15 : 17:18:44

im creating stored procedure from view i created and i get no result with i pass in parameters..
here sp

CREATE proc mysp
(@begindate datetime , @enddate datetime, @supervisor char)
as
select AVG(percentage)[ Average], [agent ID], Name,Supervisor,Manager
from Agenttool
where [date] between @begindate
and @enddate and @supervisor = supervisor
group by [agent id],supervisor,manager, name
order by manager,supervisor
GO

if i exec
mysp @begindate = '04/12/04',@enddate = '05/14/04', @supervisor = 'firstname lastname'

i get nothing
mysp work if i take out @supervisor parameter
and i can get result running query like

select * from agenttool
where supervisor ='firstname lastname'

even this works

select * from agenttool
where
[date] between '04/12/04' and '05/14/04'and
supervisor ='firstname lastname'

any idea?

densma
Starting Member

21 Posts

Posted - 2004-06-15 : 18:02:13

nevermind... got it working
didn't specify size..
change to @supervisor char(50) and it works

CREATE proc mysp
(@begindate datetime , @enddate datetime, @supervisor char(50))
as
select AVG(percentage)[ Average], [agent ID], Name,Supervisor,Manager
from Agenttool
where [date] between @begindate
and @enddate and @supervisor = supervisor
group by [agent id],supervisor,manager, name
order by manager,supervisor
GO

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources