Viewing 2 posts - 16 through 17 (of 17 total)
thanks anthony.green I'll check it and then let you know
March 15, 2012 at 4:29 am
#1459715
Hi , thanks for ur response
I got the solution,
SELECT
MARKS, STATUS
FROM
(
SELECT MARKS,
CASE WHEN MARKS >= 50 THEN 'PASS'
ELSE 'FAIL'
END AS STATUS
FROM TableName
)
AS Tmp
WHERE
STATUS = CASE
WHEN @Param = 0 THEN 'FAIL'...
March 15, 2012 at 4:12 am
#1459711