SQL Server loop – how do I loop through a set of records

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