Hi
I want to create a table that has a datetime column, data type=datetime and I want the date to start form 01/01/2004 00:00:00 to 01/01/2008 00:00:00 the increment will be by minute like
01/01/2004 00:01:00
01/01/2004 00:02:00
01/01/2004 00:03:00 and so on up to 01/01/2008 00:00:00
I will use this time dimension in bussiness objects.
please provide me with the SQL sript to do this.
CREATE TABLE DimensionTable
(
IdCol INT IDENTITY(1,1),
Timecol DATETIME
)
GO
DECLARE @.Startdate DATETIME
DECLARE @.Enddate DATETIME
SET @.Startdate = '20040101'
SET @.Enddate = '20080101'
WHILE @.Startdate < @.Enddate
BEGIN
INSERT INTO DimensionTable
(
TimeCol
)
SELECT @.Startdate
SET @.Startdate = DATEADD(mi,1,@.Startdate)
END
That could take some time :-)
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks a lot