Create a dynamic calendar in MS 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 of the week for last day of the month
  • Calendar week start date
  • Calendar week last date
  • Day of the calendar for the start date
  • Day of the calendar for the last date
Lucas Callado

Lucas Callado

Full stack developer, architect and a technical lead in the field of web engineering.
Lucas Callado

One thought on “Create a dynamic calendar in MS SQL

  1. How to Install Microsoft SQL Server (MS SQL) on RHEL (CentOS)/Ubuntu

    Appreciating the dedication you put into your site and in depth information you provide.
    It’s great to come across a blog every once in a while that isn’t the same
    out of date rehashed material. Fantastic read! I’ve bookmarked your site and I’m adding your
    RSS feeds to my Google account.

Leave a Reply

Your email address will not be published. Required fields are marked *

4 × three =