Cursor

CREATE PROCEDURE GeneratingPurchOrder
@ItemId bigint,
@Description varchar,
@Order float

AS

--SELECT * INTO #temp_TrReqDt FROM TrReqDt WHERE ItemID = @ItemId AND Description = @Description ORDER BY CreatedDate
SELECT * FROM TrReqDt WHERE ItemID = '1' AND Description = 'test' ORDER BY CreatedDate
SELECT * FROM TrReqDt WHERE ItemID = '1' AND Description = 'test' AND Status = 'MENUNGGU ORDER' ORDER BY CreatedDate

--DROP TABLE #temp_TrReqDt

DECLARE @ORDERS FLOAT = '33';
DECLARE @CHANGE FLOAT = '0';
DECLARE @PONUMBER VARCHAR;

DECLARE POINTR CURSOR FOR SELECT ID,Qty FROM TrReqDt
WHERE ItemID = '1' AND Description = 'test' AND Status = 'MENUNGGU ORDER'
ORDER BY CreatedDate

DECLARE @curID INT; DECLARE @curQty FLOAT;
OPEN POINTR; FETCH NEXT FROM POINTR INTO @curID, @curQty;

WHILE @@FETCH_STATUS = 0
BEGIN
	IF(@curQty > @ORDERS)
	BEGIN
		SET @CHANGE = @curQty - @ORDERS;
			IF(@CHANGE > @curQty)
			BEGIN
				SELECT * FROM TrPurchaseOrder WHERE CAST(CreatedDate AS DATE) = CAST(GETDATE() AS DATE)

				UPDATE TrReqDt SET Status = 'DALAM ORDER', PONumber = '' WHERE ID = @curID;
			END

		 163
		 33 > 130
		 48
		 11

	END

       PRINT CAST(@curID AS VARCHAR) + 'E ' + CAST(@curQty AS VARCHAR) + 'E ' + CAST(@ORDERS AS VARCHAR);
       FETCH NEXT FROM POINTR INTO @curID, @curQty;
END;

CLOSE POINTR;DEALLOCATE POINTR;