How to create a dates table?

• Nuts

  SSCrazy

  Points: 2547

  More actions

  November 6, 2007 at 2:55 pm

  #181021

  Hi Guys

  I need to create a master table for dates where the dates are catagorized for all the four qurters in a year.

  This is how I want my table to look like..

  Qurter/Year date

  Qrtr1-2004 1/1/2004

  Qrtr1-2004 30/02/2004

  .

  .

  .

  Qrtr1-2004 31/03/2004

  Qrtr2-2004 1/04/2004

  Qrtr2-2004 23/05/2004

  ...

  .

  .

  .

  ..

  Could you help me guys??

  Thanks

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  November 6, 2007 at 4:05 pm

  #748908

  The function on the link below is designed for loading a date table.

  Date Table Function F_TABLE_DATE

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

• Nuts

  SSCrazy

  Points: 2547

  More actions

  November 7, 2007 at 2:08 pm

  #749218

  Thanks for that. This helps

  Cheers