CREATE PROC dbo.SP_REMOVE_LIST 
AS BEGIN 
DECLARE @SAYAC INT 
DECLARE @REF INT
DECLARE @LOGREF INT 
DECLARE @AMNT INT 
DECLARE @TOP INT
SET @SAYAC=1 
SET @TOP= ISNULL((SELECT COUNT(*)FROM dbo.STOK_RAPOR_SIPARIS_VERILDI_SIRALI),0)
WHILE @SAYAC<=@TOP 
BEGIN 
SELECT @REF= USERID, @LOGREF=STOCKREF, @AMNT=AMOUNT FROM dbo.STOK_RAPOR_SIPARIS_VERILDI_SIRALI WHERE SIRA= @SAYAC
EXEC [dbo].[SP_REMOVE_ORDER] @LOGREF, @REF, @AMNT
SET @SAYAC = @SAYAC+1
END
END