Sunday, June 1, 2014

Need multiple Condition in Where Clause


Select * From LedgerTable
Where Debit + Credit >0
OR CASE WHEN @SuppressZero = 0 OR category = 'Class' THEN 1 ELSE 0 END = 1





Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c


No comments:

Post a Comment