Calendar Table - Week number of month
- by Saif Khan
I have a calendar table with data from year 2000 to 2012 (2012 wasn't intentional!). I just realize that I don't have the week number of month (e.g In January 1,2,3,4 February 1,2,3,4)
How do I go about calculating the week numbers in a month to fill this table?
Here is the table schema
CREATE TABLE [TCalendar] (
[TimeKey] [int] NOT NULL ,
…