Stored Procedure to Update a 'Set' of values instead of one-at-a-time

Question

Stored Procedure to Update a 'Set' of values instead of one-at-a-time

andegre

SSCertifiable

Points: 5875
More actions
June 17, 2010 at 3:07 pm

#141465

I have a stored procedure that is currently doing an update based on the primary key value that is being passed in the parameter. I want to be able to send a range of primary key values in the same parameter and then do the update all in one step. Is this possible?
Tahnks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

Yes.

You could provide the primary keys as a comma separated list (without blanks) and use a split string function to covert that list into a table (search for DelimitedSplit8K on this site to find an excellent performing solution).

As a result, you'd get a table with your primary keys you could use ina join ofn your update statement.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

andegre SSCertifiable Points: 5875 More actions · Answer 2

Great! Thanks again for another set-based solution for me, Lutz!

LutzM SSC Guru Points: 107049 More actions · Answer 3

My pleasure 😀

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]