When clicked in an email sent to your subscribers the recipient of this message would be redirected to the page below:
Have%20you%20ever%20needed%20to%20generate%20a%20list%20of%20dates%20for%20the%20last%2030%20days.%20%20There%20are%20lots%20of%20different%20ways%20to%20do%20this%20with%20TSQL,%20but%20one%20way%20is%20with%20a%20CTE,%20where%20you%20can%20then%20left%20join%20against%20it%20with%20another%20query%20to%20generate%20a%20list%20of%20all%20%20dates%20in%20a%20result%20set,%20along%20with%20the%20dates%20for%20the%20last%2030%20days%20that%20aren%E2%80%99t%20in%20the%20result%20set.