CREATE PROCEDURE [dbo].[sp_BarcodePrint]
    -- Add the parameters for the stored procedure here
 @ChallanNo VARCHAR(256) -- filename for backup 

AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    DECLARE @QTY int
    DECLARE @Barcode VARCHAR(256)

CREATE TABLE #temp (
ChalanNo VARCHAR(256),
QTY int,
ProductName VARCHAR(256),
BrandName VARCHAR(256),
LineName VARCHAR(256),
ModelName VARCHAR(256),
ColorName VARCHAR(256),
SizeName VARCHAR(256),
Barcode VARCHAR(256),
CostPrice VARCHAR(256),
SalesPrice VARCHAR(256),
VAT decimal,
Serial VARCHAR(256) )


DECLARE db_cursor CURSOR FOR 
    SELECT        RChallan.QTY,basicSetupItem.Barcode
    FROM            RChallan INNER JOIN
                             basicSetupItem ON RChallan.ItemID = basicSetupItem.ItemID
    WHERE        (RChallan.ChalanNo = @ChallanNo)

DECLARE @Flag INT

    OPEN db_cursor 
    FETCH NEXT FROM db_cursor INTO @QTY,@Barcode
   
   
    WHILE @@FETCH_STATUS = 0
    BEGIN
        SET @Flag = 1
        WHILE (@QTY >= @Flag) 
        BEGIN 
                 
                  INSERT INTO #temp (ChalanNo,QTY,ProductName,BrandName,LineName,ModelName,ColorName,SizeName,Barcode,CostPrice,SalesPrice,VAT,Serial)
                 
                   SELECT        RChallan.ChalanNo, RChallan.QTY, vBasicSetupItem.ProductName, vBasicSetupItem.BrandName, vBasicSetupItem.LineName, vBasicSetupItem.ModelName,
                             vBasicSetupItem.ColorName, vBasicSetupItem.SizeName, vBasicSetupItem.Barcode, vBasicSetupItem.CostPrice, vBasicSetupItem.SalesPrice,
                             vBasicSetupItem.VAT,@Flag
                    FROM            RChallan INNER JOIN
                             vBasicSetupItem ON RChallan.ItemID = vBasicSetupItem.ItemID
                    WHERE        (RChallan.ChalanNo = @ChallanNo) AND (vBasicSetupItem.Barcode =@Barcode)
                   
                    SET @Flag = @Flag + 1
        END
           FETCH NEXT FROM db_cursor INTO @QTY,@Barcode 
    END 

CLOSE db_cursor 
DEALLOCATE db_cursor

select * from #temp

drop table #temp

END