Hi,
I have a stored procedure, with "nullable" parameters.
The first line works as expected. I can't get the second line to work.
Any suggestions?
Cheers,
Julian
--(J.[Week] >= @WeekBegin OR @WeekBegin is null) AND (J.[Week] <= @WeekEnd OR @WeekEnd is null)
(J.[Week] BETWEEN (@WeekBegin OR @WeekBegin is null) AND (@WeekEnd OR @WeekEnd is null))