Went with this, but is there a way to do in where clause?
DECLARE
@mycheck int
IF @mon=1
set @mycheck = 216
else if @mon=2
set @mycheck = 244
.....
where
....
dateDiff(day,v.dateService,@myDate) < @mycheck
Results 1 to 2 of 2
Thread: Case statement in where clauseThreaded View
|
|
|