Run Procedure with Parameters in Cycle

MSSQL

22. 2. 2023
DECLARE
    @return_value Int
   ,@RowCnt       BigInt
   ,@LoadDate     Date;

CREATE TABLE loadDays
    (
        loadDay Date NOT NULL
    );
INSERT INTO loadDays
    (
        loadDay
    )
VALUES ('2021-12-31')
      ,('2021-12-30')
      ,('2021-12-29')
      ,('2021-12-28')
      ,('2021-12-27')
      ,('2021-12-26');
DECLARE CursorLoadDays CURSOR FOR SELECT loadDay FROM loadDays;

OPEN CursorLoadDays;
FETCH NEXT FROM CursorLoadDays
INTO @LoadDate;
WHILE @@Fetch_Status = 0
    BEGIN
        SELECT @LoadDate;

        EXEC @return_value = [dbo].[spDevelopment_FA_SizerunCompleteness]
            @LoadDate = @LoadDate
           ,@RowCnt = @RowCnt OUTPUT;

        SELECT @RowCnt AS N'@RowCnt';
        SELECT 'Return Value' = @return_value;

        FETCH NEXT FROM CursorLoadDays
        INTO @LoadDate;
    END;
CLOSE CursorLoadDays;
DEALLOCATE CursorLoadDays;

DROP TABLE loadDays;