Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Declare @Date1 date = '11/14/2015',
- @Date2 date = '11/17/2015';
- With TrackTime (TrackTime)
- As (Select @Date1 As TrackTime
- Union All
- Select DateAdd(day, 1, TrackTime) As TrackTime
- From TrackTime
- Where TrackTime < @Date2
- )
- Select TT.TrackTime, DateName(dw, TT.TrackTime)
- From TrackTime TT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement