Eliminate duplicate queries

[sienna]

Hi, I have a stored procedure that updates a simple table that contains 5 rows of information. Rather then have 5 queries (see below - listed 2 for sample) I was wondering if I could use some kind of loop that concatenates the number 1-5 to the end of the variables I'm sending into MS SQL query? For example @Found1, how can I attach the 1 on the end, then 2, etc.

Thanks for any help, maybe I'm already doing it the only way I can.

UPDATE Defects
SET SetCount = (SetCount + 1), NumberTimesFound = (NumberTimesFound + @Found1), NumberTimesNotFound = (NumberTimesNotFound + @NotFound1)
WHERE DefectId = @Set1

UPDATE Defects
SET SetCount = (SetCount + 1), NumberTimesFound = (NumberTimesFound + @Found2), NumberTimesNotFound = (NumberTimesNotFound + @NotFound2)
WHERE DefectId = @Set2

And this continues to 5...

[MAK]

need example data.

refer this.

http://www.databasejournal.com/featu...le.php/3373861

[skhanal]

You can build the update statement in a string variable and use sp_executesql or exec(@var) in a WHILE loop.