Dates Table in a DW

• JonJon

  Say Hey Kid

  Points: 676

  More actions

  January 29, 2008 at 2:28 pm

  #63008

  I have a dates table in a datawarehouse that has

  Date, Day, Month, Year, Quarter but missing Weeks in a month.

  I am having the most difficult of time writing the code for this.

  Does any one have something I can use, modify that will calculate the weeks in a month?

  Thanks

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 29, 2008 at 9:53 pm

  #773113

  It is rude to post the same question multiple times.

  http://www.sqlservercentral.com/Forums/Topic449091-8-1.aspx

• JonJon

  Say Hey Kid

  Points: 676

  More actions

  January 30, 2008 at 7:39 am

  #773283

  I apoligize if I did, but when posting the site gave me an error and I did not think it got posted...

  but its fun to see you have nothing better to do than add ridiculous comments.