how can i do it without using dynamic sql

When i execute the following code.

declare @ab varchar (100)

declare @cSQL varchar (200)

set @ab='''483503'',''483504'''

print @ab

SET @cSQL = 'select * from tm_temp_empmastall where employeeid in...

thanks for qiick reply

@ab will have the all employeeid selected in reporting service interface.

and then i want to pass the @ab to stored procedure to give...

i want multiple employeeids in @ab

set @ab='483503,483504'

and then

select * from tm_temp_empmastall where employeeid in (@ab)

thanks for quick reply.

When i am converting a string into datetime for comparing it with a column which is datetime why is it giving error,

This query works.

select * from tm_temp_empmastall where employeeid='483503'

and

firstly set @ab='''483503''' is creating a variable who value is '483503'

so why

select * from tm_temp_empmastall where employeeid=@ab

doesn't...

You are right .

But query mentioned below works.

select * from tm_temp_empmastall where employeeid='483503'