t-sql looping through rows in a table
Posted on 2006-11-07
I have a need to loop through the rows of a temp table, compare certain columns, and perform an update on same columns.
I'm trying to accomplish this within a stored proc (sql server 2000).
Can someone provide sample code on how to do this or suggest a better way?
Note: I'm not to worried about efficiency at this point.