DECLARE @LoopCounter INT = 1, @MaxCounts INT = (select distinct Count(prd_code) from SALES_D_ORG where INVOICE_NO=@INVOICE_NO)
WHILE(@LoopCounter <= @MaxCounts)
BEGIN
update prd_stock set AVAILABLE_STOCK=((select AVAILABLE_STOCK from prd_stock where PRD_CODE=
(Select PRD_CODE From
( Select  Row_Number() Over (Order By AUTO_NO) As RowNum, * From SALES_D_ORG Where INVOICE_NO=@INVOICE_NO) t2
Where RowNum = @LoopCounter))-(select qty from SALES_D_ORG where PRD_CODE=
(Select PRD_CODE From
( Select  Row_Number() Over (Order By AUTO_NO) As RowNum, * From SALES_D_ORG  Where INVOICE_NO=@INVOICE_NO) t2
Where RowNum = @LoopCounter))) where PRD_CODE=(Select PRD_CODE From
( Select  Row_Number() Over (Order By AUTO_NO) As RowNum, * From SALES_D_ORG  Where INVOICE_NO=@INVOICE_NO) t2
Where RowNum = @LoopCounter)
SET @LoopCounter  = @LoopCounter  + 1
END