Date Cursor Example - SQL Server , Sql Server

Language: Layout:

--------------------------------------------------------------------------------
-- Create Sample Data (process control table)
--------------------------------------------------------------------------------

CREATE TABLE #SampleData
(
    date_col       DATE NOT NULL PRIMARY KEY,
    processed_date DATETIME2(2) -- Null is unprocessed
);

INSERT INTO #SampleData (date_col, processed_date) VALUES (GetDate() -3, GetDate() -1);
INSERT INTO #SampleData (date_col, processed_date) VALUES (GetDate() -2, NULL);
INSERT INTO #SampleData (date_col, processed_date) VALUES (GetDate() -1, NULL);

--------------------------------------------------------------------------------
-- View Sample Data (process control table)
--------------------------------------------------------------------------------
SELECT *
  FROM #SampleData
 ORDER BY date_col ASC
;

--------------------------------------------------------------------------------
-- Craete Cursor
--------------------------------------------------------------------------------
DECLARE processing_date_cursor CURSOR   
    FOR
SELECT date_col
  FROM #SampleData
 WHERE processed_date IS NULL
;

--Simulate empty cursor
/*
UPDATE #SampleData
   SET processed_date = GetDate() - 1
 WHERE processed_date IS NULL
;
*/

--------------------------------------------------------------------------------
-- Iterate Cursor
--------------------------------------------------------------------------------
DECLARE @DateActive DATE;

OPEN processing_date_cursor;
FETCH NEXT FROM processing_date_cursor INTO @DateActive;

IF @@FETCH_STATUS <> 0   
    PRINT 'Empty Cursor'       
WHILE @@FETCH_STATUS = 0  
BEGIN
    PRINT CONVERT(VARCHAR, GetDate(), 120) + ' - Executing Day: ' + CONVERT(VARCHAR(20), @DateActive, 120);
    ----------------------------------------------------------------------------
    -- Process Start
    ----------------------------------------------------------------------------
    /*
    EXECUTE [DB].[Schema].[stored_procedure] @DateVariable = @DateActive;
    */

/*
    SELECT [DateField], COUNT(*) AS [count_rows]
      FROM [DB].[Schema].[table]
     WHERE [DateField] = @DateActivef
    ;
    */
    
    ----------------------------------------------------------------------------
    -- For this example, log to table
    UPDATE #SampleData
       SET processed_date = GetDate()
     WHERE date_col = @DateActive
    ;
    
    ----------------------------------------------------------------------------
    -- Process End
    ----------------------------------------------------------------------------
    FETCH NEXT FROM processing_date_cursor INTO @DateActive;
END

CLOSE processing_date_cursor;  
DEALLOCATE processing_date_cursor;

View schema
Execution time: 0,02 sec, rows selected: 6, rows affected: 5, absolute service time: 0,17 sec