Stored Proedure - pass comma seperated string

[Badgers]

Hi,

I want to pass a comma seperated into a stored procedure and use it in an IN statement like:

WHERE ID IN(@Params)

@Params = '2,4,5,6,7,8'

Without using dynamic sql, does anyone have any thoughts...?

Thanks

 

[gmmastros]

Read this: faq183-5207

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Interesting FAQs, but why I don't see the authors?

 

[gmmastros]

Because... Uh..... I dunno. Maybe the site owners don't want you to know.

I know who wrote it because the list of FAQ's make it easy to identify. Also.... at the bottom, you'll see this:

Send a Comment to ESquared About This FAQ

That's what identifies the author (believe it or not).


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ergen]

and here is diffrent solution

http://jacek-szarapa.com/index.php?p=sql&d=2

No loops used, should be faster.