HOW TO USE CURSOR

DECLARE @VariableNames DATATYPE
DECLARE @CursorName CURSOR
SET @CursorName= CURSOR FOR datasource

OPEN @CursorName

FETCH NEXT  FROM @CursorName INTO @VariableNames
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT  ‘Do Something‘
FETCH NEXT FROM  @CursorName INTO @VaribaleNames
END

CLOSE  @CursorName
DEALLOCATE @CursorName