/SQL/Sql cursor example multiple columns

Sql cursor example multiple columns

 DECLARE @OrderNo NVARCHAR(50)
       DECLARE @PoNo NVARCHAR(50)
       DECLARE @ItemNo NVARCHAR(50)
       DECLARE @BarcodeNo NVARCHAR(250)
       DECLARE @CartonNo NVARCHAR(250)
       DECLARE @Qty INT
       DECLARE @CNT INT
       DECLARE ADIDAS_CURSOR CURSOR FOR

       SELECT ORDERNUMBER,PONUMBER,ITEMLINENUMBER, Quantity, UCCNumber, CartonNumber
	   FROM [MASTER] WITH (NOLOCK)
	   WHERE HasPackingInfo = 0

       OPEN ADIDAS_CURSOR
       FETCH NEXT FROM ADIDAS_CURSOR INTO @OrderNo, @PoNo, @ItemNo, @Qty, @BarcodeNo, @CartonNo
       WHILE @@FETCH_STATUS =0
       BEGIN
             SELECT @Qty= Quantity, @BarcodeNo = BarcodeNumber, @CartonNo = CartonNumber
			 FROM Shipment_856N  WITH (NOLOCK)
             WHERE SONumber= @OrderNo AND PONumber=@PoNo AND ItemLineNumber=@ItemNo
             SET @CNT = (SELECT COUNT(*) FROM Shipment_856N  WITH (NOLOCK)
             WHERE SONumber= @OrderNo AND PONumber=@PoNo AND ItemLineNumber=@ItemNo)

             IF @CNT > 0 

             BEGIN
                 UPDATE [MASTER] SET HasPackingInfo=1, Quantity=@Qty, UCCNumber=@BarcodeNo, CartonNumber=@CartonNo
                 WHERE OrderNumber = @OrderNo AND PONumber=@PoNo AND ItemLineNumber=@ItemNo
             END

             FETCH NEXT FROM ADIDAS_CURSOR INTO @OrderNo, @PoNo, @ItemNo,  @Qty, @BarcodeNo, @CartonNo
       END

       CLOSE ADIDAS_CURSOR
       DEALLOCATE ADIDAS_CURSOR

Similar codes

1 vote143 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote149 views4 answers
Get week day from date in sql
SQL
2 votes155 views2 answers
Spring where to put the data sql
SQL
4 votes178 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote136 views1 answer
Name '_mysql' is not defined
SQL
0 vote150 views2 answers
Postgres show current role
SQL
5 votes148 views6 answers
Sql add days to date
SQL
25 votes165 views3 answers
Mysql command show tables
SQL
0 vote163 views1 answer
Django mssql backend
SQL
12 votes140 views4 answers
SQL Where
SQL