Posted by Rakesh Makhijani on 09/09/05 12:36

Sorry, I forgot to complete my code.

In SP u can use

declare @Sql varchar(8000),
@AllValues varchar(1000)

SELECT @Sql='select * from table where column IN (' + @AllValues + ') '

exec (@Sql)


Rakesh

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: select * from table where column = @AllValues?
• Prev in forum: Re: select * from table where column = @AllValues?
• Thread view: Re: select * from table where column = @AllValues?

[Reply to this message]