Updating Each Row With Diff. Value

[Creeder]

Hi all,

I have a store procedure which basically returns a unique guid value. Running it using SQL Query,

declare @guid char(20)
EXEC GetNextGUID @guid output
select @guid

@guid will have a unique value.

My question is how can i update EACH row of an ID column in a table with different @guid values return by the stored procedure? Is there such a thing as scanning through
each row and executing a code in SQL?

I am still new to SQL and any help is greatly appreciated.

Thanks in advance.

YJ

 

[Andel]

use Cursor Andel
andelbarroga@hotmail.com

http://andyb.8m.com