SET ANSI_NULLS, QUOTED_IDENTIFIER ON
DECLARE @cnt INT = 1;
DECLARE @son INT;
DECLARE @pId INT;
TRUNCATE TABLE [UNIVERSALDB].[dbo].[STR_APLUS_SECIM]
SET @son = (SELECT COUNT(*) FROM [UNIVERSALDB].[dbo].[STR_SIRALI_MALZEME_LISTESI]);
WHILE @cnt <= @son
BEGIN
SET @pId = (SELECT LOGICALREF FROM [UNIVERSALDB].[dbo].[STR_SIRALI_MALZEME_LISTESI] WHERE SIRA=@cnt)
EXEC [dbo].[SP_STR_MALZEME_RAPORU] @pId
SET @cnt = @cnt + 1;
END