Your technology certification is waiting. Enroll in Cloud Class ®
declare @t table ( key int , rnum int identity)
declare @key int
insert into @t (key) select keyfield from yourtable where ....
while @@rowcount > 0
select top 1 @key = key from @t order by rnum
if @@rowcount > 0
--- here starts the handling of the "record" with the @key information
---- end of handling @key record
delete @t where key = @key
Open in new window
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
INSERT INTO final_table ( col1, col2 ... )
SELECT col1, ( col3 + col2 ) * 344 ....
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Your question, your audience. Choose who sees your identity—and your question—with question security.