HI, I WANT A SELECT QUERY TO BE EXECUTED WHEN SOME CONDITION IS TRUE. SO IS THERE ANY WAY TO WRITE A SELECT STATEMENT INSIDE IF? ANY HELP WUD BE APPRECIATED, REGARDS

if @par=1 select * from tbl........ if @par=2 select * from tbl........ Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

T-sql forum: http://social.msdn.microsoft.com/Forums/is/transactsql/threads This is not a reporting services related question. On the other hand Uri's solution works just fine. PS. Your shift key seems to be stuck.