EXAMPLE OF CURSOR FAST_FORWARD IN SQL SERVER

DECLARE @itemcode varchar(20)
DECLARE @itemcode1 varchar(20)

DECLARE @MyCursor CURSOR

SET @MyCursor = CURSOR FAST_FORWARD
FOR
select distinct item_code from TBL_ITEM_MAST

OPEN @MyCursor
FETCH NEXT FROM @MyCursor
INTO @itemcode

WHILE @@FETCH_STATUS = 0
BEGIN

select @itemcode1 = item_code from TBL_ITEM_CONS where item_code  = @itemcode
 
PRINT @itemcode
insert into TBL_ITEM_CONS values (@itemcode,'0.000','2009')

FETCH NEXT FROM @MyCursor
INTO @itemcode
END

CLOSE @MyCursor
DEALLOCATE @MyCursor
GO