|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Calendar table01/01/2005. The table shouldd have the following columns for each row: column Example Date 1/1/2005 day 1 month 1 month name january year 2005 weekday 1 weekday name Monday weeekofyear# 1 quarter 1 I believe that SQL 7 OLAP had this type of calendar table. I don't knoww if SQL2000 Analysis service has it or not. ANy help is greatly appreciated. Bill Did you read : ?
http://www.aspfaq.com/show.asp?id=2519 HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Show quote "Bill Nguyen" <billn_nospam_please@jaco.com> schrieb im Newsbeitrag news:uBDp8LkfFHA.2496@TK2MSFTNGP15.phx.gbl... >I would like to create a calendar table starting with a base date such as >01/01/2005. > The table shouldd have the following columns for each row: > > column Example > > Date 1/1/2005 > day 1 > month 1 > month name january > year 2005 > weekday 1 > weekday name Monday > weeekofyear# 1 > quarter 1 > > > I believe that SQL 7 OLAP had this type of calendar table. I don't knoww > if SQL2000 Analysis service has it or not. > ANy help is greatly appreciated. > > Bill > > > Thank you very much, Jens & Jacco!
This is awsome! Bill Show quote "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote in message news:u1hZuQkfFHA.1204@TK2MSFTNGP12.phx.gbl... > Did you read : ? > > http://www.aspfaq.com/show.asp?id=2519 > > HTH, Jens Suessmeyer. > > --- > http://www.sqlserver2005.de > --- > > > "Bill Nguyen" <billn_nospam_please@jaco.com> schrieb im Newsbeitrag > news:uBDp8LkfFHA.2496@TK2MSFTNGP15.phx.gbl... >>I would like to create a calendar table starting with a base date such as >>01/01/2005. >> The table shouldd have the following columns for each row: >> >> column Example >> >> Date 1/1/2005 >> day 1 >> month 1 >> month name january >> year 2005 >> weekday 1 >> weekday name Monday >> weeekofyear# 1 >> quarter 1 >> >> >> I believe that SQL 7 OLAP had this type of calendar table. I don't knoww >> if SQL2000 Analysis service has it or not. >> ANy help is greatly appreciated. >> >> Bill >> >> >> > > I would like to add another column to the Calendar table:
The current Week# column "W" has the 1st day of week set to Sunday and end of Week on Saturday. I would like to add column "W2" to set 1st day of week to Monday and end of week on Sunday. What's the best way to it ? Thanks Bill Show quote "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote in message news:u1hZuQkfFHA.1204@TK2MSFTNGP12.phx.gbl... > Did you read : ? > > http://www.aspfaq.com/show.asp?id=2519 > > HTH, Jens Suessmeyer. > > --- > http://www.sqlserver2005.de > --- > > > "Bill Nguyen" <billn_nospam_please@jaco.com> schrieb im Newsbeitrag > news:uBDp8LkfFHA.2496@TK2MSFTNGP15.phx.gbl... >>I would like to create a calendar table starting with a base date such as >>01/01/2005. >> The table shouldd have the following columns for each row: >> >> column Example >> >> Date 1/1/2005 >> day 1 >> month 1 >> month name january >> year 2005 >> weekday 1 >> weekday name Monday >> weeekofyear# 1 >> quarter 1 >> >> >> I believe that SQL 7 OLAP had this type of calendar table. I don't knoww >> if SQL2000 Analysis service has it or not. >> ANy help is greatly appreciated. >> >> Bill >> >> >> > >
http://www.aspfaq.com/show.asp?id=2519
--
Show quote
Jacco Schalkwijk SQL Server MVP "Bill Nguyen" <billn_nospam_please@jaco.com> wrote in message
news:uBDp8LkfFHA.2496@TK2MSFTNGP15.phx.gbl... >I would like to create a calendar table starting with a base date such as >01/01/2005. > The table shouldd have the following columns for each row: > > column Example > > Date 1/1/2005 > day 1 > month 1 > month name january > year 2005 > weekday 1 > weekday name Monday > weeekofyear# 1 > quarter 1 > > > I believe that SQL 7 OLAP had this type of calendar table. I don't knoww > if SQL2000 Analysis service has it or not. > ANy help is greatly appreciated. > > Bill > > > 
|
|||||||||||||||||||||||
Other interesting topics