How Do I Loop Over Every Row Of A Sql Query Result Set In Sql Server?

Thank you for alternative(s), but i think Cursor would be perfect for row-by-row processing. +5

Actually i needed row-by-row processing. I mean get and store Category column value and Fieldid column value row by row as it traverses and process them to insert into table A,B,C,D according to the type of stored row column value

DECLARE @category CHAR,@fieldid INT,@fieldname VARCHAR(50)
DECLARE fieldcursor CURSOR FOR
SELECT
T.Category,
F.FieldID
,F.FieldName
FROM Field F

INNER JOIN Template T ON F.TemplateID = T.TemplateID

WHERE T.SportID = 1706-- variable @SPORTID

AND T.Category in ('R','O','A','C') -- variable @categoty

AND F.IsActive = 1

AND F.ISDutyOnChange = 1
OPEN fieldcursor
FETCH NEXT from fieldcursor into @category,@fieldid,@fieldname --ist row

while(@@FETCH_STATUS=0)
BEGIN
print @category print @fieldid print @fieldname

--My logic here
FETCH NEXT from fieldcursor into @category,@fieldid,@fieldname --Move to Second row
END

CLOSE fieldcursor
DEALLOCATE fieldcursor