SUJOY SANTRA
Monday, 28 July 2014
Use of case in where clause
SELECT
*
FROM
tableName
WHERE
dateCol
=
CASE
WHEN
@
considerDate
=
1
THEN
@
date
ELSE
dateCol
END
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)