1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
select * from master..spt_values where type ='P' order by number --Great for adding dates ie. Adding all Wednesdays between two dates DECLARE @Date1 DATE, @Date2 DATE SET @Date1 = '20190131' SET @Date2 = '20200105' SELECT --Change date to isodate Convert(varchar, DATEADD(DAY,number+1,@Date1), 112) [Date] FROM master..spt_values WHERE type = 'P' and Datename(dw, Cast(Cast(DATEADD(DAY,number+1,@Date1) as varchar) as datetime)) = 'Wednesday' AND DATEADD(DAY,number+1,@Date1) < @Date2 |