SQLTeam.com | Weblogs | Forums

Stored procedure error


#1

create proc report
@startdate date,
@enddate date
as
begin
select * from allocation
where [Date of Assign] between( @startdate = [Date of Assign] and @enddate = [Date of Assign])
end

error as fallows:
Msg 102, Level 15, State 1, Procedure report, Line 98
Incorrect syntax near '='.


#2

try this:

where [Date of Assign] between @startdate and @enddate


#3

thanks its working.