how do I loop through a set of records from a select?
So say for example I have a few records that I wish to loop through and do something with each record. Here’s a primitive version of my select:
select top 1000 * from dbo.table
where StatusID = 7
Thanks