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 '='.