CREATE PROC dbo.SP_SDR_YUKLE
AS
BEGIN
SET ANSI_NULLS, QUOTED_IDENTIFIER ON
DECLARE @cnt INT = 1;
DECLARE @son INT;
DECLARE @pId INT;
TRUNCATE TABLE [UNIVERSALDB].[dbo].[1aUNI_ortalama_eksik]
SET @son = (SELECT COUNT(*) FROM [UNIVERSALDB].[dbo].[01_sirali_urun_listesi_sdr_icin]);
WHILE @cnt <= @son
BEGIN
SET @pId = (SELECT LOGICALREF FROM [UNIVERSALDB].[dbo].[01_sirali_urun_listesi_sdr_icin] WHERE SIRA=@cnt)
EXEC [dbo].[usp_siparis_ortalama_eksik] @pId,180
SET @cnt = @cnt + 1;
END
END