I try to write a query with sql that get one parameter and use this parameter in where section of below query but get error: I want do this :
if @state equal with 2 Check in where condition @state=2
if @state equal with 3 Check in where condition @state=3
if @state equal with 0 then don't Check in where condition
I try to write this statement with case but get syntax error
SELECT *
FROM tbl1
WHERE @StartDate <= Cast([date] AS DATE)
AND Cast([date] AS DATE) <= @endDate
AND [reservetype] = @Type
AND CASE
WHEN @State = 2 THEN [state]=2
WHEN @State = 3 THEN [state]=3
WHEN @State = 0 then ....
END
Aucun commentaire:
Enregistrer un commentaire