[AccessD] Need some help

Hi Robert

Some strange data types here? For example:

         [DAY_OF_WEEK] [varchar](50) NULL: SmallInt or Byte?
         [DAY_MONTH_NO] [int] NULL: SmallInt or Byte?
         [QUARTER_NO] [int] NULL: Byte?
         [HOLIDAY_FLG] [varchar](50) NULL: Bit?
         [WEEKDAY_FLG] [varchar](50) NULL: Bit?
         [LAST_DAY_IN_MONTH_FLG] [varchar](50) NULL: Bit?

/gustav

>>> robert at webedb.com 26-09-2008 19:40 >>>
Steve,

What you need to do is use a date dimension table. Something like this:

CREATE TABLE [dbo].[tblDateDimension](
         [DATE_ID] [datetime] NULL,
         [DAY_OF_WEEK] [varchar](50) NULL,
         [DAY_MONTH_NO] [int] NULL,
         [DAY_MONTH_TXT] [varchar](12) NULL,
         [DAY_YEAR_NO] [smallint] NULL,
         [DAY_OVERALL_NO] [int] NULL,
         [WEEK_YEAR_NO] [int] NULL,
         [WEEK_OVERALL_NO] [int] NULL,
         [MONTH_NO] [int] NULL,
         [MONTH_TXT] [varchar](15) NULL,
         [MONTH_OVERALL_NO] [int] NULL,
         [QUARTER_NO] [int] NULL,
         [FISCAL_PERIOD] [varchar](50) NULL,
         [HOLIDAY_FLG] [varchar](50) NULL,
         [WEEKDAY_FLG] [varchar](50) NULL,
         [LAST_DAY_IN_MONTH_FLG] [varchar](50) NULL,
         [YEAR_NO] [smallint] NULL,
         [CREATION_DATE] [datetime] NULL,
         [APP_LOGIN_CREATION] [varchar](50) NULL,
         [MODIFICATION_DATE] [datetime] NULL,
         [APP_LOGIN_MODIFICATION] [varchar](50) NULL
) ON [PRIMARY]