T-SQL Code to Loop One Day at a Time
Jamey Johnston (@STATCowboy)
Hidden in my SQL Server 2016 Security Demo blog post is a neat T-SQL trick to loop through a date range day by day (check out the “2 – Oil&Gas RLS Demo – LoadTables.sql” script when you download the code)! But to give you a simpler example the gist of the code in the script is this:
DECLARE @StartDate DATE = ‘2016-10-01’;
DECLARE @EndDate DATE = ‘2016-10-31’;
WHILE (@StartDate <= @EndDate)
BEGIN
print @StartDate;
— Do Something like call a proc with the variable @StartDate
set @StartDate = DATEADD(day, 1, @StartDate);
END;
As you can see this is simple code and works like a charm! Hope you enjoy and hit me up on Twitter (@STATCowboy) if you have questions or improvements to the T-SQL Code!