delimited list, and then use a like clause instead of an in clause...
where ',' + @parameter + ',' like '%,' + columname + ',%'
otherwise there aren't really any great ways (as far as I'm concerned)
to use IN and a list with a stored procedure... IN and a sub-select is
another story.
hth
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
