Hi,
Check the following Script...
DECLARE @SqlQuery VARCHAR(1000), @param int
SELECT @param = 1, @SqlQuery =''
IF @param = 1
BEGIN
SELECT @SqlQuery = 'Select col1,col2,col3 from table1 WHERE ASOfDate = '''05/24/2013''' AND CloseCode NOT IN (2,3,8)'
END
ELSE IF @param = 2
BEGIN
SELECT @SqlQuery = 'Select col1,col2,col3 from table1 WHERE ASOfDate = '''05/24/2013''' AND CloseCode IN (2,3,8)'
END
EXEC (@SqlQuery)
DECLARE @param int
SET @param = 1
Select col1,col2,col3 from table1
WHERE table1.ASOfDate = '05/24/2013'
AND( (@param = 1 AND CloseCode NOT IN (2,3,8)) OR
(@param = 2 AND CloseCode IN (2,3,8))
)
Regards,
GVPrabu