Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using "in" clause in Stored Procedure without "Exec"

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-10 : 07:50:23
Manish writes "Hi,

I want to achieve something as shown below.

If EXISTS(Select * from ABC where Column1 in (@Parameter))
BEGIN
...Some Code...
END

@Parameter will be supplied to this procedure.
@Parameter is comma separated int value (ex:- '1,2,3,4')

Please let me know how to do it.

Thanks in Advance,
Manish "

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-10-10 : 08:51:36
http://www.sqlteam.com/item.asp?ItemID=11499
http://www.sqlteam.com/item.asp?ItemID=2652
http://www.sqlteam.com/item.asp?ItemID=637

Jay White
{0}
Go to Top of Page
   

- Advertisement -