Database – SQL

Create a dynamic calendar in MS SQL

Create a dynamic calendar in MS SQL

First result set will give you a two-week period, and the day of the week for each date. Second result set will give more information like: Previous month Next month First day of month Last day of month Day of the week for first day of the month Day…