Thanks Chuck,

That seems to be the only option that I was running across as well. I've been trying to get used to the differences between 2000 and 2005 while...

when you are querying the datetime field with an = are you including the time portion or just the date? if you want to pull 2007/02/14 and the data...

CREATE TABLE [dbo].[SHIP_Fact] (

[dateID] [int] NULL ,

[vend_ID] [int] NULL ,

[upcID] [int] NULL ,

[pos_dept_ID] [int] NULL ,

[location_ID] [int] NULL ,

[ord_type_ID] [int] NULL ,

[out_rsn_ID] [int] NULL ,

[invc_nbr] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

I'm thinking maybe something like

TimeSpanID

Timespan_Act

Timespan_1Min

Timespan_5Min

Timespan_15Min

Timespan_30Min

TimespanID|Timespan_Act|Timespan_1Min|Timespan_5Min|Timespan_15Min|Timespan_30min

1|00:00:01|00:01:00|00:05:00|00:15:00|00:30:00

2|00:00:02|00:01:00|00:05:00|00:15:00|00:30:00

3|00:00:03|00:01:00|00:05:00|00:15:00|00:30:00

...

90|00:01:30|00:02:00|00:05:00|00:15:00|00:30:00

91|00:01:31|00:02:00|00:05:00|00:15:00|00:30:00

...

301|00:05:01|00:06:00|00:10:00|00:15:00|00:30:00

First thing you need to so is look at your 'time' dimension table. What fields do you have in it?

Yeah, One of the classes that we were looking at from a local training company was Course 2780 - Maintaining a Microsoft SQL Server 2005 Database. Anyone have experience...

Well right now we do pretty much everything except for the administration of the server. We are responsible for creating the databases, DTS packages, cubes and reports. I...