SQL: For Each Loop

Easy way to loop through records in a table.

declare @cursor cursor, @customerID int

set @cursor = cursor for select CustomerId from StoreUpdates

open @cursor

while 1=1

begin

fetch from @cursor into @customerID

if @@fetch_status 0

break

update Stores set Name = (select StoreName from StoreUpdates where CustomerId = @customerID) where CustomerId = @customerID;

end

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s