How to use case in where statement
Can someone help me to get this query to work?
DECLARE @option bit
,@begindate datetime
,@enddate datetime
/@paymentdate datetime
Set @option = 1
,@begindate = ‘2/1/2012’
,@enddate = ‘2/20/2012’
,@paymentdate = '2/8/2012'
Select * from inventory i
where i.TransactionType = '810'
and (CASE @option
WHEN 1 THEN i.PaymentDueDate between @begindate and @enddate
ELSE i.CreateDate between @begindate and @enddate
END)
|