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;