Friday, October 4, 2013

Cursor in SQL Server Insert 1 Row Item Code wise 0 Qty

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

No comments:

Post a Comment