DECLARE @Cursor CURSOR 

DECLARE @colA VARCHAR(100) 



SET @Cursor = CURSOR FAST_FORWARD 

FOR 

SELECT * FROM tableName WHERE Something = something



-- Now Open & Loop Through the Cursor

OPEN @Cursor 

FETCH NEXT FROM @Cursor 

INTO @ColA



WHILE @@FETCH_STATUS = 0 

BEGIN 

   -- Loop throught the cursor



   FETCH NEXT FROM @Cursor 

   INTO @ColA

END 



--Clear And Tidy Up

CLOSE @Cursor 

DEALLOCATE @Cursor