Stored Procedure - Performance Issue

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Stored Procedure - Performance Issue

Author

Topic

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 10:08:03

Hello,

I have some troubles to improve sql performance on following procedure which is the core procedure of an high load application. There are about 2 millions entry in the TBRValue table. I already improved indexes manually and using the profiler index tuning wizard but i'm sure that my sql code is not optimal, i use 2 subqueries which I think it's possible to write as joins but I'm not enough skilled or maybe clever

to do it.

The stored procedure has to return 1 record for each record in the TbrTimeTime for a defined TimeType. E.G if the type is hourly, then I should return 24 values which correspond to each hours of the day.

If I keep the hourly example, for one hour I can have several values in the TBRValue table for that IdTime and I need to filter them out to get only one. Those values in TBRValue can have different versions and different priorities. For each hour I need to extract a single record which corresponds to the value having the highest priority and the highest version number for that hour. Notice that priority can also be undefined.

Any help would be appreciated.

Kindly

Gilles


CREATE PROCEDURE [dbo].[GetValueByIdColumnDateIdTimeType]
    @IdColumn int,	
    @DateValue datetime,
    @IdTimeType int
	
AS
SELECT ttt.Title, Val.*
FROM TBLTime t 
  LEFT JOIN TBRValue val ON val.IdTime = t.IdTime 
    AND val.IdColumn = @IdColumn 
    AND dbo.DateTimeToDateOnly(Val.DateValue) = dbo.DateTimeToDateOnly(@DateValue)
    AND (val.IdTso = (
      SELECT TOP 1 Prio.IdTso     
      FROM TBRPriority prio 
        INNER JOIN TBRValue val2 ON Prio.IdColumn = val2.IdColumn AND Prio.IdTso = val2.IdTso
      WHERE 
       prio.IdColumn = @IdColumn 
       AND dbo.DateTimeToDateOnly(val2.DateValue) = dbo.DateTimeToDateOnly(@DateValue)
       AND val2.IdTime = val.IdTime
	    ORDER BY PriorityOrder ASC)
      OR NOT EXISTS(SELECT IdPriority FROM TBRPriority WHERE IdColumn = val.IdColumn) OR val.IdTso is null)
     AND (val.Version = (
      SELECT MAX(Version) 
      FROM TbrValue 
      WHERE IdColumn = val.IdColumn AND IdTime = val.IdTime AND IdTso = val.IdTso AND dbo.DateTimeToDateOnly(datevalue) = dbo.DateTimeToDateOnly(@DateValue)) OR val.Version is null)
  LEFT JOIN TBLColumn col ON col.IdColumn = val.IdColumn 
  LEFT JOIN TBRTimeTimeType ttt ON t.IdTime = ttt.IdTime  

WHERE
  ttt.IdTimeType = @IdTimeType   
AND t.IsDayLightEnd = 0  
ORDER BY ttt.IdTime

[URL=http://img264.imageshack.us/my.php?image=diagram8nz.gif]

[/URL]

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 10:47:53

Please post sample data, and your expected output based on the provided sample data.
I think we can come up with something clever here...

Peter Larsson
Helsingborg, Sweden

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 13:03:09

Hello Peter,

I hope it's possible to build a cleverer procedure and improve performance. I'll post some scripts to be able to test datas. I hope it helps.

Regards

Gilles

Tables creation script


GO
/****** Object:  Table [dbo].[TBLTso]    Script Date: 01/22/2007 18:29:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBLTso](
	[IdTso] [int] IDENTITY(1,1) NOT NULL,
	[IdZone] [int] NULL,
	[Identifier] [nvarchar](255)  NULL,
	[Name] [nvarchar](1000)  NULL,
	[Address] [nvarchar](255)  NULL,
	[Phone] [nvarchar](255)  NULL,
	[Fax] [nvarchar](255)  NULL,
	[Url] [nvarchar](255)  NULL,
	[Email] [nvarchar](255)  NULL,
	[IsOperationalDataProvider] [bit] NULL,
	[IsAuctionDataProvider] [bit] NULL,
	[FTPUploadFolderName] [nvarchar](50)  NULL,
	[GMT] [nvarchar](2)  NULL,
	[Remark] [nvarchar](1000)  NULL,
	[Status] [int] NULL,
	[LastModificationDate] [datetime] NULL,
	[CreationDate] [datetime] NULL,
	[LastModifiedBy] [nvarchar](50)  NULL,
	[IsDefault] [bit] NULL,
	[SortOrder] [bit] NULL,
 CONSTRAINT [PK_TB_TSO] PRIMARY KEY CLUSTERED 
(
	[IdTso] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
 CONSTRAINT [IX_UNIQUE_TB_TSO] UNIQUE NONCLUSTERED 
(
	[Identifier] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


/****** Object:  Table [dbo].[TBCTimeType]    Script Date: 01/22/2007 18:28:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBCTimeType](
	[IdTimeType] [int] IDENTITY(1,1) NOT NULL,
	[TimeTypeName] [nvarchar](255)  NOT NULL,
 CONSTRAINT [PK_TBCTIMETYPE] PRIMARY KEY CLUSTERED 
(
	[IdTimeType] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]




/****** Object:  Table [dbo].[TBLColumn]    Script Date: 01/22/2007 18:28:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBLColumn](
	[IdColumn] [int] IDENTITY(1,1) NOT NULL,
	[IdZoneFrom] [int] NULL,
	[IdZoneTo] [int] NULL,
	[IdColumnType] [int] NOT NULL,
	[IdPeriodicity] [int] NULL,
	[IdTimeType] [int] NULL,
	[Identifier] [nvarchar](255)  NOT NULL,
	[Header] [nvarchar](255)  NULL,
	[Arrow] [int] NULL,
	[Description] [nvarchar](255)  NULL,
	[Remarks] [nvarchar](255)  NULL,
	[ValueSign] [nvarchar](255)  NULL,
	[Status] [int] NOT NULL,
	[LastModificationDate] [datetime] NULL,
	[CreationDate] [datetime] NULL,
	[LastModifiedBy] [nvarchar](255)  NULL,
	[IsDefault] [bit] NULL,
	[SortOrder] [int] NULL,
 CONSTRAINT [PK_TB_COLUMNARRAY] PRIMARY KEY CLUSTERED 
(
	[IdColumn] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]



ALTER TABLE [dbo].[TBLColumn]  WITH CHECK ADD  CONSTRAINT [FK_TBLColumn_TBCTimeType] FOREIGN KEY([IdTimeType])
REFERENCES [dbo].[TBCTimeType] ([IdTimeType])
GO

/****** Object:  Table [dbo].[TBRPriority]    Script Date: 01/22/2007 18:29:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBRPriority](
	[IdPriority] [int] IDENTITY(1,1) NOT NULL,
	[IdTSO] [int] NOT NULL,
	[IdColumn] [int] NOT NULL,
	[PriorityOrder] [int] NOT NULL,
 CONSTRAINT [PK_TBRPRIORITY] PRIMARY KEY CLUSTERED 
(
	[IdPriority] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TBRPriority]  WITH CHECK ADD  CONSTRAINT [FK_TBRPRIOR_REFERENCE_TBLCOLUM] FOREIGN KEY([IdColumn])
REFERENCES [dbo].[TBLColumn] ([IdColumn])
GO
ALTER TABLE [dbo].[TBRPriority]  WITH CHECK ADD  CONSTRAINT [FK_TBRPRIOR_REFERENCE_TBLTSO] FOREIGN KEY([IdTSO])
REFERENCES [dbo].[TBLTso] ([IdTso])


/****** Object:  Table [dbo].[TBLTime]    Script Date: 01/22/2007 18:27:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TBLTime](
	[IdTime] [int] IDENTITY(1,1) NOT NULL,
	[Label] [varchar](255)  NOT NULL,
	[SortOrder] [int] NOT NULL,
	[IsTotal] [bit] NOT NULL,
	[IsDayLightStart] [bit] NOT NULL,
	[IsDayLightEnd] [bit] NOT NULL,
 CONSTRAINT [PK_TB_LINEARRAY] PRIMARY KEY CLUSTERED 
(
	[IdTime] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object:  Table [dbo].[TBRTimeTimeType]    Script Date: 01/22/2007 18:27:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBRTimeTimeType](
	[IdTimeTimeType] [int] IDENTITY(1,1) NOT NULL,
	[IdTime] [int] NOT NULL,
	[IdTimeType] [int] NOT NULL,
	[Title] [nvarchar](255)  NOT NULL,
 CONSTRAINT [PK_TBRTIMETIMETYPE] PRIMARY KEY CLUSTERED 
(
	[IdTimeTimeType] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[TBRTimeTimeType]  WITH CHECK ADD  CONSTRAINT [FK_TBRTIMET_REFERENCE_TBCTIMET] FOREIGN KEY([IdTimeType])
REFERENCES [dbo].[TBCTimeType] ([IdTimeType])
GO
ALTER TABLE [dbo].[TBRTimeTimeType]  WITH CHECK ADD  CONSTRAINT [FK_TBRTIMET_REFERENCE_TBLTIME] FOREIGN KEY([IdTime])
REFERENCES [dbo].[TBLTime] ([IdTime])


GO
/****** Object:  Table [dbo].[TBRValue]    Script Date: 01/22/2007 18:26:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TBRValue](
	[IdValue] [int] IDENTITY(1,1) NOT NULL,
	[IdColumn] [int] NOT NULL,
	[IdTime] [int] NOT NULL,
	[NumValue] [decimal](9, 3) NULL,
	[DateValue] [datetime] NULL,
	[Status] [int] NOT NULL,
	[CreationDate] [datetime] NULL,
	[LastModificationDate] [datetime] NOT NULL,
	[LastModifiedBy] [nvarchar](255)  NULL,
	[IsDefault] [bit] NULL,
	[SortOrder] [int] NULL,
	[Version] [int] NOT NULL CONSTRAINT [DF_TBRValue_Version]  DEFAULT ((1)),
	[IdTso] [int] NOT NULL,
 CONSTRAINT [PK_TB_VALUE] PRIMARY KEY CLUSTERED 
(
	[IdValue] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Statistic [_dta_stat_510624862_2_13_5]    Script Date: 01/22/2007 18:26:53 ******/
CREATE STATISTICS [_dta_stat_510624862_2_13_5] ON [dbo].[TBRValue]([IdColumn], [IdTso], [DateValue])
GO
/****** Object:  Statistic [_dta_stat_510624862_3_13_12_5_2]    Script Date: 01/22/2007 18:26:53 ******/
CREATE STATISTICS [_dta_stat_510624862_3_13_12_5_2] ON [dbo].[TBRValue]([IdTime], [IdTso], [Version], [DateValue], [IdColumn])
GO
/****** Object:  Statistic [_dta_stat_510624862_3_13_5]    Script Date: 01/22/2007 18:26:53 ******/
CREATE STATISTICS [_dta_stat_510624862_3_13_5] ON [dbo].[TBRValue]([IdTime], [IdTso], [DateValue])
GO
/****** Object:  Statistic [_dta_stat_510624862_3_5_2]    Script Date: 01/22/2007 18:26:53 ******/
CREATE STATISTICS [_dta_stat_510624862_3_5_2] ON [dbo].[TBRValue]([IdTime], [DateValue], [IdColumn])
GO
/****** Object:  Statistic [_dta_stat_510624862_5_2]    Script Date: 01/22/2007 18:26:53 ******/
CREATE STATISTICS [_dta_stat_510624862_5_2] ON [dbo].[TBRValue]([DateValue], [IdColumn])
GO
GO
ALTER TABLE [dbo].[TBRValue]  WITH CHECK ADD  CONSTRAINT [FK_TB_VALUE_TB_COLUMNARRAY] FOREIGN KEY([IdColumn])
REFERENCES [dbo].[TBLColumn] ([IdColumn])
GO
ALTER TABLE [dbo].[TBRValue]  WITH CHECK ADD  CONSTRAINT [FK_TB_VALUE_TB_LINEARRAY] FOREIGN KEY([IdTime])
REFERENCES [dbo].[TBLTime] ([IdTime])
GO
ALTER TABLE [dbo].[TBRValue]  WITH CHECK ADD  CONSTRAINT [FK_TBRValue_TBLTso] FOREIGN KEY([IdTso])
REFERENCES [dbo].[TBLTso] ([IdTso])

/****** Object: UserDefinedFunction [dbo].[DateTimeToDateOnly] Script Date: 01/22/2007 18:59:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[DateTimeToDateOnly]
(@DateAndTime AS datetime)
RETURNS datetime
AS
/*****************************************
* return date without time for datetime
*****************************************/
BEGIN
RETURN CAST(ROUND(CAST(@DateAndTime AS float),0,1) AS datetime)
END

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 13:07:30

Sample data (Part 1)

SET NOCOUNT ON
 
SET IDENTITY_INSERT [TblTso] ON
GO
 
 
PRINT 'Inserting values into [TblTso]'
INSERT INTO [TblTso] ([IdTso],[IdZone],[Identifier],[Name],[Address],[Phone],[Fax],[Url],[Email],[IsOperationalDataProvider],[IsAuctionDataProvider],[FTPUploadFolderName],[GMT],[Remark],[Status],[LastModificationDate],[CreationDate],[LastModifiedBy],[IsDefault],[SortOrder])VALUES(6,7,'10X1001A1001A094','TSO1',NULL,NULL,NULL,NULL,NULL,1,0,'eii','0',NULL,1,'Oct 24 2006  3:30:27:290PM','Oct 24 2006  3:39:51:253PM','Gilles Faessler',0,NULL)
INSERT INTO [TblTso] ([IdTso],[IdZone],[Identifier],[Name],[Address],[Phone],[Fax],[Url],[Email],[IsOperationalDataProvider],[IsAuctionDataProvider],[FTPUploadFolderName],[GMT],[Remark],[Status],[LastModificationDate],[CreationDate],[LastModifiedBy],[IsDefault],[SortOrder])VALUES(27,31,'10X1001A1001A361','TSO2',NULL,NULL,NULL,NULL,NULL,1,1,'ten','0',NULL,1,'Oct 24 2006  3:40:39:273PM','Oct 24 2006  3:39:51:253PM','Gilles Faessler',0,NULL)
INSERT INTO [TblTso] ([IdTso],[IdZone],[Identifier],[Name],[Address],[Phone],[Fax],[Url],[Email],[IsOperationalDataProvider],[IsAuctionDataProvider],[FTPUploadFolderName],[GMT],[Remark],[Status],[LastModificationDate],[CreationDate],[LastModifiedBy],[IsDefault],[SortOrder])VALUES(40,9,'TSO3','TSO3',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,1,NULL,NULL,'Gilles Faessler',0,NULL)
PRINT 'Done'
 
 
SET IDENTITY_INSERT [TblTso] OFF
GO
SET NOCOUNT OFF

SET NOCOUNT ON
 
SET IDENTITY_INSERT [tbcTimeType] ON
GO
 
 
PRINT 'Inserting values into [tbcTimeType]'
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(1,'quarter')
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(2,'hour')
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(3,'halfhour')
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(4,'Undefined')
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(5,'Load')
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(6,'Product')
INSERT INTO [tbcTimeType] ([IdTimeType],[TimeTypeName])VALUES(7,'Single')
PRINT 'Done'
 
SET IDENTITY_INSERT [tbcTimeType] OFF
GO

SET NOCOUNT ON
 
SET IDENTITY_INSERT [TBLColumn] ON
GO
 
 
PRINT 'Inserting values into [TBLColumn]'
INSERT INTO [TBLColumn] ([IdColumn],[IdZoneFrom],[IdZoneTo],[IdColumnType],[IdPeriodicity],[IdTimeType],[Identifier],[Header],[Arrow],[Description],[Remarks],[ValueSign],[Status],[LastModificationDate],[CreationDate],[LastModifiedBy],[IsDefault],[SortOrder])VALUES(418,7,31,2,1,2,'SCHEDULE_10YBE----------2-10YNL----------L','BE -> NL',3,NULL,NULL,NULL,1,'Oct 24 2006  6:17:50:987PM','Oct 24 2006  6:17:50:987PM','Nadia Balet',0,NULL)
PRINT 'Done'
 
 
SET IDENTITY_INSERT [TBLColumn] OFF
GO
SET NOCOUNT OFF

SET NOCOUNT ON
 
SET IDENTITY_INSERT [TBRPriority] ON
GO
 
 
PRINT 'Inserting values into [TBRPriority]'
INSERT INTO [TBRPriority] ([IdPriority],[IdTSO],[IdColumn],[PriorityOrder])VALUES(259,27,418,2)
INSERT INTO [TBRPriority] ([IdPriority],[IdTSO],[IdColumn],[PriorityOrder])VALUES(363,6,418,1)
INSERT INTO [TBRPriority] ([IdPriority],[IdTSO],[IdColumn],[PriorityOrder])VALUES(982,40,418,0)
PRINT 'Done'
 
 
SET IDENTITY_INSERT [TBRPriority] OFF
GO
SET NOCOUNT OFF

SET NOCOUNT ON
 
SET IDENTITY_INSERT [tbltime] ON
GO
 
 
PRINT 'Inserting values into [tbltime]'
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(1,'00:00:00-00:05:00',1,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(2,'00:05:00-00:10:00',2,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(3,'00:10:00-00:15:00',3,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(4,'00:15:00-00:20:00',4,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(5,'00:20:00-00:25:00',5,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(6,'00:25:00-00:30:00',6,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(7,'00:30:00-00:35:00',7,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(8,'00:35:00-00:40:00',8,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(9,'00:40:00-00:45:00',9,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(10,'00:45:00-00:50:00',10,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(11,'00:50:00-00:55:00',11,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(12,'00:55:00-01:00:00',12,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(13,'01:00:00-01:05:00',13,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(14,'01:05:00-01:10:00',14,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(15,'01:10:00-01:15:00',15,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(16,'01:15:00-01:20:00',16,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(17,'01:20:00-01:25:00',17,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(18,'01:25:00-01:30:00',18,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(19,'01:30:00-01:35:00',19,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(20,'01:35:00-01:40:00',20,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(21,'01:40:00-01:45:00',21,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(22,'01:45:00-01:50:00',22,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(23,'01:50:00-01:55:00',23,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(24,'01:55:00-02:00:00',24,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(25,'02:00:00-02:05:00',25,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(26,'02:05:00-02:10:00',26,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(27,'02:10:00-02:15:00',27,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(28,'02:15:00-02:20:00',28,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(29,'02:20:00-02:25:00',29,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(30,'02:25:00-02:30:00',30,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(31,'02:30:00-02:35:00',31,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(32,'02:35:00-02:40:00',32,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(33,'02:40:00-02:45:00',33,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(34,'02:45:00-02:50:00',34,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(35,'02:50:00-02:55:00',35,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(36,'02:55:00-03:00:00',36,0,1,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(37,'03:00:00-03:05:00',37,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(38,'03:05:00-03:10:00',38,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(39,'03:10:00-03:15:00',39,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(40,'03:15:00-03:20:00',40,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(41,'03:20:00-03:25:00',41,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(42,'03:25:00-03:30:00',42,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(43,'03:30:00-03:35:00',43,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(44,'03:35:00-03:40:00',44,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(45,'03:40:00-03:45:00',45,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(46,'03:45:00-03:50:00',46,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(47,'03:50:00-03:55:00',47,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(48,'03:55:00-04:00:00',48,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(49,'04:00:00-04:05:00',49,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(50,'04:05:00-04:10:00',50,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(51,'04:10:00-04:15:00',51,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(52,'04:15:00-04:20:00',52,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(53,'04:20:00-04:25:00',53,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(54,'04:25:00-04:30:00',54,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(55,'04:30:00-04:35:00',55,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(56,'04:35:00-04:40:00',56,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(57,'04:40:00-04:45:00',57,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(58,'04:45:00-04:50:00',58,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(59,'04:50:00-04:55:00',59,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(60,'04:55:00-05:00:00',60,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(61,'05:00:00-05:05:00',61,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(62,'05:05:00-05:10:00',62,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(63,'05:10:00-05:15:00',63,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(64,'05:15:00-05:20:00',64,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(65,'05:20:00-05:25:00',65,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(66,'05:25:00-05:30:00',66,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(67,'05:30:00-05:35:00',67,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(68,'05:35:00-05:40:00',68,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(69,'05:40:00-05:45:00',69,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(70,'05:45:00-05:50:00',70,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(71,'05:50:00-05:55:00',71,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(72,'05:55:00-06:00:00',72,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(73,'06:00:00-06:05:00',73,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(74,'06:05:00-06:10:00',74,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(75,'06:10:00-06:15:00',75,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(76,'06:15:00-06:20:00',76,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(77,'06:20:00-06:25:00',77,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(78,'06:25:00-06:30:00',78,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(79,'06:30:00-06:35:00',79,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(80,'06:35:00-06:40:00',80,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(81,'06:40:00-06:45:00',81,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(82,'06:45:00-06:50:00',82,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(83,'06:50:00-06:55:00',83,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(84,'06:55:00-07:00:00',84,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(85,'07:00:00-07:05:00',85,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(86,'07:05:00-07:10:00',86,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(87,'07:10:00-07:15:00',87,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(88,'07:15:00-07:20:00',88,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(89,'07:20:00-07:25:00',89,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(90,'07:25:00-07:30:00',90,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(91,'07:30:00-07:35:00',91,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(92,'07:35:00-07:40:00',92,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(93,'07:40:00-07:45:00',93,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(94,'07:45:00-07:50:00',94,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(95,'07:50:00-07:55:00',95,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(96,'07:55:00-08:00:00',96,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(97,'08:00:00-08:05:00',97,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(98,'08:05:00-08:10:00',98,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(99,'08:10:00-08:15:00',99,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(100,'08:15:00-08:20:00',100,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(101,'08:20:00-08:25:00',101,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(102,'08:25:00-08:30:00',102,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(103,'08:30:00-08:35:00',103,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(104,'08:35:00-08:40:00',104,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(105,'08:40:00-08:45:00',105,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(106,'08:45:00-08:50:00',106,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(107,'08:50:00-08:55:00',107,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(108,'08:55:00-09:00:00',108,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(109,'09:00:00-09:05:00',109,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(110,'09:05:00-09:10:00',110,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(111,'09:10:00-09:15:00',111,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(112,'09:15:00-09:20:00',112,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(113,'09:20:00-09:25:00',113,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(114,'09:25:00-09:30:00',114,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(115,'09:30:00-09:35:00',115,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(116,'09:35:00-09:40:00',116,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(117,'09:40:00-09:45:00',117,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(118,'09:45:00-09:50:00',118,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(119,'09:50:00-09:55:00',119,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(120,'09:55:00-10:00:00',120,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(121,'10:00:00-10:05:00',121,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(122,'10:05:00-10:10:00',122,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(123,'10:10:00-10:15:00',123,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(124,'10:15:00-10:20:00',124,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(125,'10:20:00-10:25:00',125,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(126,'10:25:00-10:30:00',126,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(127,'10:30:00-10:35:00',127,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(128,'10:35:00-10:40:00',128,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(129,'10:40:00-10:45:00',129,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(130,'10:45:00-10:50:00',130,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(131,'10:50:00-10:55:00',131,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(132,'10:55:00-11:00:00',132,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(133,'11:00:00-11:05:00',133,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(134,'11:05:00-11:10:00',134,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(135,'11:10:00-11:15:00',135,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(136,'11:15:00-11:20:00',136,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(137,'11:20:00-11:25:00',137,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(138,'11:25:00-11:30:00',138,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(139,'11:30:00-11:35:00',139,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(140,'11:35:00-11:40:00',140,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(141,'11:40:00-11:45:00',141,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(142,'11:45:00-11:50:00',142,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(143,'11:50:00-11:55:00',143,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(144,'11:55:00-12:00:00',144,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(145,'12:00:00-12:05:00',145,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(146,'12:05:00-12:10:00',146,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(147,'12:10:00-12:15:00',147,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(148,'12:15:00-12:20:00',148,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(149,'12:20:00-12:25:00',149,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(150,'12:25:00-12:30:00',150,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(151,'12:30:00-12:35:00',151,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(152,'12:35:00-12:40:00',152,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(153,'12:40:00-12:45:00',153,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(154,'12:45:00-12:50:00',154,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(155,'12:50:00-12:55:00',155,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(156,'12:55:00-13:00:00',156,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(157,'13:00:00-13:05:00',157,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(158,'13:05:00-13:10:00',158,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(159,'13:10:00-13:15:00',159,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(160,'13:15:00-13:20:00',160,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(161,'13:20:00-13:25:00',161,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(162,'13:25:00-13:30:00',162,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(163,'13:30:00-13:35:00',163,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(164,'13:35:00-13:40:00',164,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(165,'13:40:00-13:45:00',165,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(166,'13:45:00-13:50:00',166,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(167,'13:50:00-13:55:00',167,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(168,'13:55:00-14:00:00',168,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(169,'14:00:00-14:05:00',169,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(170,'14:05:00-14:10:00',170,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(171,'14:10:00-14:15:00',171,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(172,'14:15:00-14:20:00',172,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(173,'14:20:00-14:25:00',173,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(174,'14:25:00-14:30:00',174,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(175,'14:30:00-14:35:00',175,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(176,'14:35:00-14:40:00',176,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(177,'14:40:00-14:45:00',177,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(178,'14:45:00-14:50:00',178,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(179,'14:50:00-14:55:00',179,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(180,'14:55:00-15:00:00',180,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(181,'15:00:00-15:05:00',181,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(182,'15:05:00-15:10:00',182,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(183,'15:10:00-15:15:00',183,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(184,'15:15:00-15:20:00',184,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(185,'15:20:00-15:25:00',185,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(186,'15:25:00-15:30:00',186,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(187,'15:30:00-15:35:00',187,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(188,'15:35:00-15:40:00',188,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(189,'15:40:00-15:45:00',189,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(190,'15:45:00-15:50:00',190,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(191,'15:50:00-15:55:00',191,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(192,'15:55:00-16:00:00',192,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(193,'16:00:00-16:05:00',193,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(194,'16:05:00-16:10:00',194,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(195,'16:10:00-16:15:00',195,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(196,'16:15:00-16:20:00',196,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(197,'16:20:00-16:25:00',197,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(198,'16:25:00-16:30:00',198,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(199,'16:30:00-16:35:00',199,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(200,'16:35:00-16:40:00',200,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(201,'16:40:00-16:45:00',201,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(202,'16:45:00-16:50:00',202,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(203,'16:50:00-16:55:00',203,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(204,'16:55:00-17:00:00',204,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(205,'17:00:00-17:05:00',205,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(206,'17:05:00-17:10:00',206,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(207,'17:10:00-17:15:00',207,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(208,'17:15:00-17:20:00',208,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(209,'17:20:00-17:25:00',209,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(210,'17:25:00-17:30:00',210,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(211,'17:30:00-17:35:00',211,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(212,'17:35:00-17:40:00',212,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(213,'17:40:00-17:45:00',213,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(214,'17:45:00-17:50:00',214,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(215,'17:50:00-17:55:00',215,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(216,'17:55:00-18:00:00',216,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(217,'18:00:00-18:05:00',217,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(218,'18:05:00-18:10:00',218,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(219,'18:10:00-18:15:00',219,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(220,'18:15:00-18:20:00',220,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(221,'18:20:00-18:25:00',221,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(222,'18:25:00-18:30:00',222,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(223,'18:30:00-18:35:00',223,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(224,'18:35:00-18:40:00',224,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(225,'18:40:00-18:45:00',225,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(226,'18:45:00-18:50:00',226,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(227,'18:50:00-18:55:00',227,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(228,'18:55:00-19:00:00',228,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(229,'19:00:00-19:05:00',229,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(230,'19:05:00-19:10:00',230,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(231,'19:10:00-19:15:00',231,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(232,'19:15:00-19:20:00',232,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(233,'19:20:00-19:25:00',233,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(234,'19:25:00-19:30:00',234,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(235,'19:30:00-19:35:00',235,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(236,'19:35:00-19:40:00',236,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(237,'19:40:00-19:45:00',237,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(238,'19:45:00-19:50:00',238,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(239,'19:50:00-19:55:00',239,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(240,'19:55:00-20:00:00',240,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(241,'20:00:00-20:05:00',241,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(242,'20:05:00-20:10:00',242,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(243,'20:10:00-20:15:00',243,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(244,'20:15:00-20:20:00',244,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(245,'20:20:00-20:25:00',245,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(246,'20:25:00-20:30:00',246,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(247,'20:30:00-20:35:00',247,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(248,'20:35:00-20:40:00',248,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(249,'20:40:00-20:45:00',249,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(250,'20:45:00-20:50:00',250,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(251,'20:50:00-20:55:00',251,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(252,'20:55:00-21:00:00',252,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(253,'21:00:00-21:05:00',253,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(254,'21:05:00-21:10:00',254,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(255,'21:10:00-21:15:00',255,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(256,'21:15:00-21:20:00',256,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(257,'21:20:00-21:25:00',257,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(258,'21:25:00-21:30:00',258,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(259,'21:30:00-21:35:00',259,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(260,'21:35:00-21:40:00',260,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(261,'21:40:00-21:45:00',261,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(262,'21:45:00-21:50:00',262,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(263,'21:50:00-21:55:00',263,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(264,'21:55:00-22:00:00',264,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(265,'22:00:00-22:05:00',265,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(266,'22:05:00-22:10:00',266,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(267,'22:10:00-22:15:00',267,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(268,'22:15:00-22:20:00',268,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(269,'22:20:00-22:25:00',269,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(270,'22:25:00-22:30:00',270,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(271,'22:30:00-22:35:00',271,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(272,'22:35:00-22:40:00',272,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(273,'22:40:00-22:45:00',273,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(274,'22:45:00-22:50:00',274,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(275,'22:50:00-22:55:00',275,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(276,'22:55:00-23:00:00',276,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(277,'23:00:00-23:05:00',277,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(278,'23:05:00-23:10:00',278,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(279,'23:10:00-23:15:00',279,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(280,'23:15:00-23:20:00',280,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(281,'23:20:00-23:25:00',281,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(282,'23:25:00-23:30:00',282,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(283,'23:30:00-23:35:00',283,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(284,'23:35:00-23:40:00',284,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(285,'23:40:00-23:45:00',285,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(286,'23:45:00-23:50:00',286,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(287,'23:50:00-23:55:00',287,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(288,'23:55:00-00:00:00',288,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(289,'TOTAL',289,1,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(290,'Su->Wi 1',290,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(291,'Su->Wi 2',291,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(292,'Su->Wi 3',292,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(293,'Su->Wi 4',293,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(294,'Su->Wi 5',294,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(295,'Su->Wi 6',295,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(296,'Su->Wi 7',296,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(297,'Su->Wi 8',297,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(298,'Su->Wi 9',298,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(299,'Su->Wi 10',299,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(300,'Su->Wi 11',300,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(301,'Su->Wi 12',301,0,0,1)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(302,'Su->Wi 13',302,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(303,'Su->Wi 14',303,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(304,'-',304,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(305,'-',305,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(306,'-',306,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(307,'-',307,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(308,'-',308,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(309,'-',309,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(310,'-',310,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(311,'-',311,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(312,'-',312,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(313,'-',313,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(315,'BaseLoad',314,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(316,'PeakLoad',315,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(317,'Base Product',316,0,0,0)
INSERT INTO [tbltime] ([IdTime],[Label],[SortOrder],[IsTotal],[IsDayLightStart],[IsDayLightEnd])VALUES(318,'Complementary Product',317,0,0,0)

PRINT 'Done'
 
 
SET IDENTITY_INSERT [tbltime] OFF
GO
SET NOCOUNT OFF

SET NOCOUNT ON
 
SET IDENTITY_INSERT [TbrTimeTimeType] ON
GO
 
 
PRINT 'Inserting values into [TbrTimeTimeType]'
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(1,3,1,'00.00-00.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(2,6,1,'00.15-00.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(3,9,1,'00.30-00.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(4,12,1,'00.45-01.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(5,15,1,'01.00-01.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(6,18,1,'01.15-01.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(7,21,1,'01.30-01.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(8,24,1,'01.45-02.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(9,27,1,'02.00-02.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(10,30,1,'02.15-02.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(11,33,1,'02.30-02.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(12,36,1,'02.45-03.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(13,39,1,'03.00-03.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(14,42,1,'03.15-03.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(15,45,1,'03.30-03.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(16,48,1,'03.45-04.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(17,51,1,'04.00-04.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(18,54,1,'04.15-04.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(19,57,1,'04.30-04.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(20,60,1,'04.45-05.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(21,63,1,'05.00-05.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(22,66,1,'05.15-05.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(23,69,1,'05.30-05.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(24,72,1,'05.45-06.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(25,75,1,'06.00-06.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(26,78,1,'06.15-06.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(27,81,1,'06.30-06.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(28,84,1,'06.45-07.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(29,87,1,'07.00-07.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(30,90,1,'07.15-07.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(31,93,1,'07.30-07.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(32,96,1,'07.45-08.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(33,99,1,'08.00-08.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(34,102,1,'08.15-08.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(35,105,1,'08.30-08.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(36,108,1,'08.45-09.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(37,111,1,'09.00-09.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(38,114,1,'09.15-09.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(39,117,1,'09.30-09.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(40,120,1,'09.45-10.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(41,123,1,'10.00-10.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(42,126,1,'10.15-10.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(43,129,1,'10.30-10.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(44,132,1,'10.45-11.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(45,135,1,'11.00-11.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(46,138,1,'11.15-11.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(47,141,1,'11.30-11.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(48,144,1,'11.45-12.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(49,147,1,'12.00-12.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(50,150,1,'12.15-12.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(51,153,1,'12.30-12.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(52,156,1,'12.45-13.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(53,159,1,'13.00-13.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(54,162,1,'13.15-13.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(55,165,1,'13.30-13.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(56,168,1,'13.45-14.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(57,171,1,'14.00-14.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(58,174,1,'14.15-14.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(59,177,1,'14.30-14.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(60,180,1,'14.45-15.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(61,183,1,'15.00-15.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(62,186,1,'15.15-15.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(63,189,1,'15.30-15.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(64,192,1,'15.45-16.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(65,195,1,'16.00-16.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(66,198,1,'16.15-16.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(67,201,1,'16.30-16.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(68,204,1,'16.45-17.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(69,207,1,'17.00-17.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(70,210,1,'17.15-17.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(71,213,1,'17.30-17.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(72,216,1,'17.45-18.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(73,219,1,'18.00-18.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(74,222,1,'18.15-18.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(75,225,1,'18.30-18.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(76,228,1,'18.45-19.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(77,231,1,'19.00-19.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(78,234,1,'19.15-19.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(79,237,1,'19.30-19.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(80,240,1,'19.45-20.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(81,243,1,'20.00-20.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(82,246,1,'20.15-20.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(83,249,1,'20.30-20.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(84,252,1,'20.45-21.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(85,255,1,'21.00-21.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(86,258,1,'21.15-21.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(87,261,1,'21.30-21.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(88,264,1,'21.45-22.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(89,267,1,'22.00-22.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(90,270,1,'22.15-22.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(91,273,1,'22.30-22.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(92,276,1,'22.45-23.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(93,279,1,'23.00-23.15')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(94,282,1,'23.15-23.30')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(95,285,1,'23.30-23.45')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(96,288,1,'23.45-00.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(97,12,2,'00.00-01.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(98,24,2,'01.00-02.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(99,36,2,'02.00-03.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(100,48,2,'03.00-04.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(101,60,2,'04.00-05.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(102,72,2,'05.00-06.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(103,84,2,'06.00-07.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(104,96,2,'07.00-08.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(105,108,2,'08.00-09.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(106,120,2,'09.00-10.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(107,132,2,'10.00-11.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(108,144,2,'11.00-12.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(109,156,2,'12.00-13.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(110,168,2,'13.00-14.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(111,180,2,'14.00-15.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(112,192,2,'15.00-16.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(113,204,2,'16.00-17.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(114,216,2,'17.00-18.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(115,228,2,'18.00-19.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(116,240,2,'19.00-20.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(117,252,2,'20.00-21.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(118,264,2,'21.00-22.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(119,276,2,'22.00-23.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(120,288,2,'23.00-00.00')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(122,304,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(123,305,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(124,306,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(125,307,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(126,308,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(127,309,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(128,310,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(129,311,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(130,312,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(131,313,4,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(132,315,5,'Base Load')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(133,316,5,'Peak Load')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(134,317,6,'Base Product')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(135,318,6,'Complementary Product')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(137,304,7,'')
INSERT INTO [TbrTimeTimeType] ([IdTimeTimeType],[IdTime],[IdTimeType],[Title])VALUES(138,301,2,'Su->Wi')

PRINT 'Done'
 
 
SET IDENTITY_INSERT [TbrTimeTimeType] OFF
GO
SET NOCOUNT OFF

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 13:11:49

Sample Data (Part2)


SET NOCOUNT ON
 
SET IDENTITY_INSERT [tbrValue] ON
GO
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663069,418,252,588.100,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:213PM','Dec  6 2006  3:11:49:213PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684722,418,252,588.100,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:730PM','Dec  7 2006 12:02:41:730PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677571,418,252,588.100,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:620AM','Dec  8 2006  7:25:38:620AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818161,418,252,588.000,'Dec  7 2006 12:00:00:000AM',1,'Jan  8 2007  7:45:16:020PM','Jan  8 2007  7:45:16:020PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663262,418,255,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:073PM','Dec  6 2006  3:11:55:073PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678343,418,255,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:58:980AM','Dec  8 2006  7:25:58:980AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663070,418,255,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:213PM','Dec  6 2006  3:11:49:213PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684723,418,255,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:743PM','Dec  7 2006 12:02:41:743PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677572,418,255,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:620AM','Dec  8 2006  7:25:38:620AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663263,418,258,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:073PM','Dec  6 2006  3:11:55:073PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678344,418,258,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:58:980AM','Dec  8 2006  7:25:58:980AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663071,418,258,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:213PM','Dec  6 2006  3:11:49:213PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684724,418,258,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:743PM','Dec  7 2006 12:02:41:743PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677573,418,258,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:620AM','Dec  8 2006  7:25:38:620AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663264,418,261,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:073PM','Dec  6 2006  3:11:55:073PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678345,418,261,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:58:993AM','Dec  8 2006  7:25:58:993AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663072,418,261,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:230PM','Dec  6 2006  3:11:49:230PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684725,418,261,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:743PM','Dec  7 2006 12:02:41:743PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677574,418,261,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:637AM','Dec  8 2006  7:25:38:637AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663265,418,264,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:073PM','Dec  6 2006  3:11:55:073PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678346,418,264,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:58:993AM','Dec  8 2006  7:25:58:993AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663073,418,264,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:230PM','Dec  6 2006  3:11:49:230PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684726,418,264,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:743PM','Dec  7 2006 12:02:41:743PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677575,418,264,363.300,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:637AM','Dec  8 2006  7:25:38:637AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(816788,418,264,363.000,'Dec  7 2006 12:00:00:000AM',1,'Jan  8 2007  7:24:13:020PM','Jan  8 2007  7:24:13:020PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663266,418,267,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:090PM','Dec  6 2006  3:11:55:090PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678347,418,267,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:58:993AM','Dec  8 2006  7:25:58:993AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663074,418,267,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:230PM','Dec  6 2006  3:11:49:230PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684727,418,267,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:760PM','Dec  7 2006 12:02:41:760PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677576,418,267,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:637AM','Dec  8 2006  7:25:38:637AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663267,418,270,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:090PM','Dec  6 2006  3:11:55:090PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678348,418,270,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:58:993AM','Dec  8 2006  7:25:58:993AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663075,418,270,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:230PM','Dec  6 2006  3:11:49:230PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684728,418,270,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:760PM','Dec  7 2006 12:02:41:760PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677577,418,270,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:637AM','Dec  8 2006  7:25:38:637AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663268,418,273,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:090PM','Dec  6 2006  3:11:55:090PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678349,418,273,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:59:010AM','Dec  8 2006  7:25:59:010AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663076,418,273,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:243PM','Dec  6 2006  3:11:49:243PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684729,418,273,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:760PM','Dec  7 2006 12:02:41:760PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677578,418,273,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:650AM','Dec  8 2006  7:25:38:650AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663269,418,276,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:55:090PM','Dec  6 2006  3:11:55:090PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678350,418,276,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:59:010AM','Dec  8 2006  7:25:59:010AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663077,418,276,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  6 2006  3:11:49:243PM','Dec  6 2006  3:11:49:243PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684730,418,276,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  7 2006 12:02:41:760PM','Dec  7 2006 12:02:41:760PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677579,418,276,125.800,'Dec  7 2006 12:00:00:000AM',1,'Dec  8 2006  7:25:38:650AM','Dec  8 2006  7:25:38:650AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818308,418,276,126.000,'Dec  7 2006 12:00:00:000AM',1,'Jan  8 2007  6:51:04:627PM','Jan  8 2007  6:51:04:627PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818226,418,288,406.000,'Dec  7 2006 12:00:00:000AM',1,'Jan  8 2007  5:55:12:973PM','Jan  8 2007  5:55:12:973PM',NULL,0,NULL,1,40)

PRINT 'Done'
 
 
SET IDENTITY_INSERT [tbrValue] OFF
GO
SET NOCOUNT OFF

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 13:14:22

And your expected output based on all these sample data?

Peter Larsson
Helsingborg, Sweden

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 13:14:22

Sample Data (Part 3)

SET NOCOUNT ON

SET IDENTITY_INSERT [tbrValue] ON
GO

PRINT 'Inserting values into [tbrValue]'
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663178,418,3,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:730PM','Dec 6 2006 3:11:54:730PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678259,418,3,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:637AM','Dec 8 2006 7:25:58:637AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662986,418,3,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:870PM','Dec 6 2006 3:11:48:870PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684639,418,3,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:400PM','Dec 7 2006 12:02:41:400PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677488,418,3,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:277AM','Dec 8 2006 7:25:38:277AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663179,418,6,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:730PM','Dec 6 2006 3:11:54:730PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678260,418,6,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:650AM','Dec 8 2006 7:25:58:650AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662987,418,6,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:887PM','Dec 6 2006 3:11:48:887PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684640,418,6,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:400PM','Dec 7 2006 12:02:41:400PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677489,418,6,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:293AM','Dec 8 2006 7:25:38:293AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663180,418,9,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:743PM','Dec 6 2006 3:11:54:743PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678261,418,9,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:650AM','Dec 8 2006 7:25:58:650AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662988,418,9,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:887PM','Dec 6 2006 3:11:48:887PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684641,418,9,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:417PM','Dec 7 2006 12:02:41:417PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677490,418,9,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:293AM','Dec 8 2006 7:25:38:293AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663181,418,12,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:743PM','Dec 6 2006 3:11:54:743PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678262,418,12,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:650AM','Dec 8 2006 7:25:58:650AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662989,418,12,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:887PM','Dec 6 2006 3:11:48:887PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684642,418,12,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:417PM','Dec 7 2006 12:02:41:417PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677491,418,12,349.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:293AM','Dec 8 2006 7:25:38:293AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(816424,418,12,350.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 9:48:53:987PM','Jan 8 2007 9:48:53:987PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663182,418,15,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:743PM','Dec 6 2006 3:11:54:743PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678263,418,15,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:650AM','Dec 8 2006 7:25:58:650AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662990,418,15,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:900PM','Dec 6 2006 3:11:48:900PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684643,418,15,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:417PM','Dec 7 2006 12:02:41:417PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677492,418,15,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:293AM','Dec 8 2006 7:25:38:293AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663183,418,18,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:743PM','Dec 6 2006 3:11:54:743PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678264,418,18,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:667AM','Dec 8 2006 7:25:58:667AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662991,418,18,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:900PM','Dec 6 2006 3:11:48:900PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684644,418,18,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:417PM','Dec 7 2006 12:02:41:417PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677493,418,18,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:307AM','Dec 8 2006 7:25:38:307AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663184,418,21,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:760PM','Dec 6 2006 3:11:54:760PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678265,418,21,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:667AM','Dec 8 2006 7:25:58:667AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662992,418,21,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:900PM','Dec 6 2006 3:11:48:900PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684645,418,21,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:433PM','Dec 7 2006 12:02:41:433PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677494,418,21,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:307AM','Dec 8 2006 7:25:38:307AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663185,418,24,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:760PM','Dec 6 2006 3:11:54:760PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678266,418,24,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:667AM','Dec 8 2006 7:25:58:667AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662993,418,24,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:900PM','Dec 6 2006 3:11:48:900PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684646,418,24,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:433PM','Dec 7 2006 12:02:41:433PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677495,418,24,290.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:307AM','Dec 8 2006 7:25:38:307AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(816901,418,24,291.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:59:39:177PM','Jan 8 2007 5:59:39:177PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663186,418,27,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:760PM','Dec 6 2006 3:11:54:760PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678267,418,27,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:667AM','Dec 8 2006 7:25:58:667AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662994,418,27,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:917PM','Dec 6 2006 3:11:48:917PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684647,418,27,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:433PM','Dec 7 2006 12:02:41:433PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677496,418,27,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:323AM','Dec 8 2006 7:25:38:323AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663187,418,30,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:760PM','Dec 6 2006 3:11:54:760PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678268,418,30,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:683AM','Dec 8 2006 7:25:58:683AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662995,418,30,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:917PM','Dec 6 2006 3:11:48:917PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684648,418,30,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:433PM','Dec 7 2006 12:02:41:433PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677497,418,30,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:323AM','Dec 8 2006 7:25:38:323AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663188,418,33,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:777PM','Dec 6 2006 3:11:54:777PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678269,418,33,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:683AM','Dec 8 2006 7:25:58:683AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662996,418,33,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:917PM','Dec 6 2006 3:11:48:917PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684649,418,33,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:447PM','Dec 7 2006 12:02:41:447PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677498,418,33,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:323AM','Dec 8 2006 7:25:38:323AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663189,418,36,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:777PM','Dec 6 2006 3:11:54:777PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678270,418,36,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:683AM','Dec 8 2006 7:25:58:683AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662997,418,36,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:917PM','Dec 6 2006 3:11:48:917PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684650,418,36,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:447PM','Dec 7 2006 12:02:41:447PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677499,418,36,769.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:323AM','Dec 8 2006 7:25:38:323AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818346,418,36,769.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:58:44:207PM','Jan 8 2007 5:58:44:207PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663190,418,39,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:777PM','Dec 6 2006 3:11:54:777PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678271,418,39,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:683AM','Dec 8 2006 7:25:58:683AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662998,418,39,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:933PM','Dec 6 2006 3:11:48:933PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684651,418,39,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:447PM','Dec 7 2006 12:02:41:447PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677500,418,39,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:340AM','Dec 8 2006 7:25:38:340AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663191,418,42,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:777PM','Dec 6 2006 3:11:54:777PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678272,418,42,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:697AM','Dec 8 2006 7:25:58:697AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(662999,418,42,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:933PM','Dec 6 2006 3:11:48:933PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684652,418,42,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:447PM','Dec 7 2006 12:02:41:447PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677501,418,42,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:340AM','Dec 8 2006 7:25:38:340AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663192,418,45,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:793PM','Dec 6 2006 3:11:54:793PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678273,418,45,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:697AM','Dec 8 2006 7:25:58:697AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663000,418,45,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:933PM','Dec 6 2006 3:11:48:933PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684653,418,45,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:463PM','Dec 7 2006 12:02:41:463PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677502,418,45,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:340AM','Dec 8 2006 7:25:38:340AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663193,418,48,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:793PM','Dec 6 2006 3:11:54:793PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678274,418,48,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:697AM','Dec 8 2006 7:25:58:697AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663001,418,48,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:933PM','Dec 6 2006 3:11:48:933PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684654,418,48,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:463PM','Dec 7 2006 12:02:41:463PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677503,418,48,877.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:340AM','Dec 8 2006 7:25:38:340AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817520,418,48,878.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:52:23:597PM','Jan 8 2007 5:52:23:597PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663194,418,51,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:793PM','Dec 6 2006 3:11:54:793PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678275,418,51,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:713AM','Dec 8 2006 7:25:58:713AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663002,418,51,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:947PM','Dec 6 2006 3:11:48:947PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684655,418,51,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:463PM','Dec 7 2006 12:02:41:463PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677504,418,51,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:353AM','Dec 8 2006 7:25:38:353AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663195,418,54,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:793PM','Dec 6 2006 3:11:54:793PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678276,418,54,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:713AM','Dec 8 2006 7:25:58:713AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663003,418,54,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:947PM','Dec 6 2006 3:11:48:947PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684656,418,54,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:463PM','Dec 7 2006 12:02:41:463PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677505,418,54,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:353AM','Dec 8 2006 7:25:38:353AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663196,418,57,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:807PM','Dec 6 2006 3:11:54:807PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678277,418,57,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:713AM','Dec 8 2006 7:25:58:713AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663004,418,57,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:947PM','Dec 6 2006 3:11:48:947PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684657,418,57,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:480PM','Dec 7 2006 12:02:41:480PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677506,418,57,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:353AM','Dec 8 2006 7:25:38:353AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663197,418,60,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:807PM','Dec 6 2006 3:11:54:807PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678278,418,60,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:713AM','Dec 8 2006 7:25:58:713AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663005,418,60,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:947PM','Dec 6 2006 3:11:48:947PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684658,418,60,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:480PM','Dec 7 2006 12:02:41:480PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677507,418,60,423.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:353AM','Dec 8 2006 7:25:38:353AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818139,418,60,424.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:48:56:533PM','Jan 8 2007 5:48:56:533PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663198,418,63,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:807PM','Dec 6 2006 3:11:54:807PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678279,418,63,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:730AM','Dec 8 2006 7:25:58:730AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663006,418,63,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:963PM','Dec 6 2006 3:11:48:963PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684659,418,63,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:480PM','Dec 7 2006 12:02:41:480PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677508,418,63,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:370AM','Dec 8 2006 7:25:38:370AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663199,418,66,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:807PM','Dec 6 2006 3:11:54:807PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678280,418,66,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:730AM','Dec 8 2006 7:25:58:730AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663007,418,66,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:963PM','Dec 6 2006 3:11:48:963PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684660,418,66,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:480PM','Dec 7 2006 12:02:41:480PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677509,418,66,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:370AM','Dec 8 2006 7:25:38:370AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663200,418,69,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:823PM','Dec 6 2006 3:11:54:823PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678281,418,69,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:730AM','Dec 8 2006 7:25:58:730AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663008,418,69,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:963PM','Dec 6 2006 3:11:48:963PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684661,418,69,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:493PM','Dec 7 2006 12:02:41:493PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677510,418,69,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:370AM','Dec 8 2006 7:25:38:370AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663201,418,72,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:823PM','Dec 6 2006 3:11:54:823PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678282,418,72,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:730AM','Dec 8 2006 7:25:58:730AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663009,418,72,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:963PM','Dec 6 2006 3:11:48:963PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684662,418,72,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:493PM','Dec 7 2006 12:02:41:493PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677511,418,72,0.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:370AM','Dec 8 2006 7:25:38:370AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(816105,418,72,0.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 9:54:38:893PM','Jan 8 2007 9:54:38:893PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663202,418,75,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:823PM','Dec 6 2006 3:11:54:823PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678283,418,75,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:743AM','Dec 8 2006 7:25:58:743AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663010,418,75,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:980PM','Dec 6 2006 3:11:48:980PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684663,418,75,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:493PM','Dec 7 2006 12:02:41:493PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677512,418,75,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:387AM','Dec 8 2006 7:25:38:387AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663203,418,78,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:823PM','Dec 6 2006 3:11:54:823PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678284,418,78,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:743AM','Dec 8 2006 7:25:58:743AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663011,418,78,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:980PM','Dec 6 2006 3:11:48:980PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684664,418,78,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:493PM','Dec 7 2006 12:02:41:493PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677513,418,78,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:387AM','Dec 8 2006 7:25:38:387AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663204,418,81,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:840PM','Dec 6 2006 3:11:54:840PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678285,418,81,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:743AM','Dec 8 2006 7:25:58:743AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663012,418,81,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:980PM','Dec 6 2006 3:11:48:980PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684665,418,81,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:510PM','Dec 7 2006 12:02:41:510PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677514,418,81,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:387AM','Dec 8 2006 7:25:38:387AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663205,418,84,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:840PM','Dec 6 2006 3:11:54:840PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678286,418,84,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:743AM','Dec 8 2006 7:25:58:743AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663013,418,84,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:980PM','Dec 6 2006 3:11:48:980PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684666,418,84,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:510PM','Dec 7 2006 12:02:41:510PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677515,418,84,707.300,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:387AM','Dec 8 2006 7:25:38:387AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817722,418,84,707.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:54:28:847PM','Jan 8 2007 5:54:28:847PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663206,418,87,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:840PM','Dec 6 2006 3:11:54:840PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678287,418,87,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:760AM','Dec 8 2006 7:25:58:760AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663014,418,87,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:993PM','Dec 6 2006 3:11:48:993PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684667,418,87,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:510PM','Dec 7 2006 12:02:41:510PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677516,418,87,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:400AM','Dec 8 2006 7:25:38:400AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663207,418,90,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:840PM','Dec 6 2006 3:11:54:840PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678288,418,90,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:760AM','Dec 8 2006 7:25:58:760AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663015,418,90,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:993PM','Dec 6 2006 3:11:48:993PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684668,418,90,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:510PM','Dec 7 2006 12:02:41:510PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677517,418,90,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:400AM','Dec 8 2006 7:25:38:400AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663208,418,93,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:853PM','Dec 6 2006 3:11:54:853PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678289,418,93,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:760AM','Dec 8 2006 7:25:58:760AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663016,418,93,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:993PM','Dec 6 2006 3:11:48:993PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684669,418,93,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:527PM','Dec 7 2006 12:02:41:527PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677518,418,93,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:400AM','Dec 8 2006 7:25:38:400AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663209,418,96,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:853PM','Dec 6 2006 3:11:54:853PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678290,418,96,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:760AM','Dec 8 2006 7:25:58:760AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663017,418,96,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:48:993PM','Dec 6 2006 3:11:48:993PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684670,418,96,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:527PM','Dec 7 2006 12:02:41:527PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677519,418,96,703.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:400AM','Dec 8 2006 7:25:38:400AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818029,418,96,703.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 8:17:05:020PM','Jan 8 2007 8:17:05:020PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663210,418,99,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:853PM','Dec 6 2006 3:11:54:853PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678291,418,99,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:777AM','Dec 8 2006 7:25:58:777AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663018,418,99,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:010PM','Dec 6 2006 3:11:49:010PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684671,418,99,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:527PM','Dec 7 2006 12:02:41:527PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677520,418,99,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:417AM','Dec 8 2006 7:25:38:417AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663211,418,102,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:870PM','Dec 6 2006 3:11:54:870PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678292,418,102,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:777AM','Dec 8 2006 7:25:58:777AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663019,418,102,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:010PM','Dec 6 2006 3:11:49:010PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684672,418,102,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:527PM','Dec 7 2006 12:02:41:527PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677521,418,102,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:417AM','Dec 8 2006 7:25:38:417AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663212,418,105,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:870PM','Dec 6 2006 3:11:54:870PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678293,418,105,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:777AM','Dec 8 2006 7:25:58:777AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663020,418,105,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:010PM','Dec 6 2006 3:11:49:010PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684673,418,105,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:543PM','Dec 7 2006 12:02:41:543PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677522,418,105,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:417AM','Dec 8 2006 7:25:38:417AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663213,418,108,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:870PM','Dec 6 2006 3:11:54:870PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678294,418,108,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:777AM','Dec 8 2006 7:25:58:777AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663021,418,108,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:010PM','Dec 6 2006 3:11:49:010PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684674,418,108,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:543PM','Dec 7 2006 12:02:41:543PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677523,418,108,1094.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:417AM','Dec 8 2006 7:25:38:417AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817414,418,108,1095.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 6:24:02:723PM','Jan 8 2007 6:24:02:723PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663214,418,111,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:870PM','Dec 6 2006 3:11:54:870PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678295,418,111,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:793AM','Dec 8 2006 7:25:58:793AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663022,418,111,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:027PM','Dec 6 2006 3:11:49:027PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684675,418,111,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:543PM','Dec 7 2006 12:02:41:543PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677524,418,111,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:433AM','Dec 8 2006 7:25:38:433AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663215,418,114,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:887PM','Dec 6 2006 3:11:54:887PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678296,418,114,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:793AM','Dec 8 2006 7:25:58:793AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663023,418,114,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:027PM','Dec 6 2006 3:11:49:027PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684676,418,114,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:557PM','Dec 7 2006 12:02:41:557PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677525,418,114,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:433AM','Dec 8 2006 7:25:38:433AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663216,418,117,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:887PM','Dec 6 2006 3:11:54:887PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678297,418,117,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:793AM','Dec 8 2006 7:25:58:793AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663024,418,117,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:027PM','Dec 6 2006 3:11:49:027PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684677,418,117,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:557PM','Dec 7 2006 12:02:41:557PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677526,418,117,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:433AM','Dec 8 2006 7:25:38:433AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663217,418,120,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:887PM','Dec 6 2006 3:11:54:887PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678298,418,120,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:793AM','Dec 8 2006 7:25:58:793AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663025,418,120,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:043PM','Dec 6 2006 3:11:49:043PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684678,418,120,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:557PM','Dec 7 2006 12:02:41:557PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677527,418,120,1080.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:433AM','Dec 8 2006 7:25:38:433AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818266,418,120,1080.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:48:31:253PM','Jan 8 2007 5:48:31:253PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663218,418,123,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:887PM','Dec 6 2006 3:11:54:887PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678299,418,123,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:807AM','Dec 8 2006 7:25:58:807AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663026,418,123,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:043PM','Dec 6 2006 3:11:49:043PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684679,418,123,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:557PM','Dec 7 2006 12:02:41:557PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677528,418,123,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:447AM','Dec 8 2006 7:25:38:447AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663219,418,126,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:900PM','Dec 6 2006 3:11:54:900PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678300,418,126,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:807AM','Dec 8 2006 7:25:58:807AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663027,418,126,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:043PM','Dec 6 2006 3:11:49:043PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684680,418,126,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:573PM','Dec 7 2006 12:02:41:573PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677529,418,126,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:447AM','Dec 8 2006 7:25:38:447AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663220,418,129,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:900PM','Dec 6 2006 3:11:54:900PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678301,418,129,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:807AM','Dec 8 2006 7:25:58:807AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663028,418,129,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:043PM','Dec 6 2006 3:11:49:043PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684681,418,129,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:573PM','Dec 7 2006 12:02:41:573PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677530,418,129,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:447AM','Dec 8 2006 7:25:38:447AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663221,418,132,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:900PM','Dec 6 2006 3:11:54:900PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678302,418,132,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:807AM','Dec 8 2006 7:25:58:807AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663029,418,132,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:057PM','Dec 6 2006 3:11:49:057PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684682,418,132,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:573PM','Dec 7 2006 12:02:41:573PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677531,418,132,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:463AM','Dec 8 2006 7:25:38:463AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817264,418,132,1039.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:43:35:627PM','Jan 8 2007 5:43:35:627PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663222,418,135,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:900PM','Dec 6 2006 3:11:54:900PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678303,418,135,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:823AM','Dec 8 2006 7:25:58:823AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663030,418,135,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:057PM','Dec 6 2006 3:11:49:057PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684683,418,135,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:573PM','Dec 7 2006 12:02:41:573PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677532,418,135,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:463AM','Dec 8 2006 7:25:38:463AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663223,418,138,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:917PM','Dec 6 2006 3:11:54:917PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678304,418,138,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:823AM','Dec 8 2006 7:25:58:823AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663031,418,138,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:057PM','Dec 6 2006 3:11:49:057PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684684,418,138,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:590PM','Dec 7 2006 12:02:41:590PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677533,418,138,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:463AM','Dec 8 2006 7:25:38:463AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663224,418,141,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:917PM','Dec 6 2006 3:11:54:917PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678305,418,141,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:823AM','Dec 8 2006 7:25:58:823AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663032,418,141,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:057PM','Dec 6 2006 3:11:49:057PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684685,418,141,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:590PM','Dec 7 2006 12:02:41:590PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677534,418,141,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:463AM','Dec 8 2006 7:25:38:463AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663225,418,144,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:917PM','Dec 6 2006 3:11:54:917PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678306,418,144,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:823AM','Dec 8 2006 7:25:58:823AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663033,418,144,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:073PM','Dec 6 2006 3:11:49:073PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684686,418,144,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:590PM','Dec 7 2006 12:02:41:590PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677535,418,144,1083.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:480AM','Dec 8 2006 7:25:38:480AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817800,418,144,1083.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:49:00:893PM','Jan 8 2007 5:49:00:893PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663226,418,147,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:917PM','Dec 6 2006 3:11:54:917PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678307,418,147,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:840AM','Dec 8 2006 7:25:58:840AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663034,418,147,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:073PM','Dec 6 2006 3:11:49:073PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684687,418,147,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:590PM','Dec 7 2006 12:02:41:590PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677536,418,147,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:480AM','Dec 8 2006 7:25:38:480AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663227,418,150,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:933PM','Dec 6 2006 3:11:54:933PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678308,418,150,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:840AM','Dec 8 2006 7:25:58:840AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663035,418,150,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:073PM','Dec 6 2006 3:11:49:073PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684688,418,150,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:603PM','Dec 7 2006 12:02:41:603PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677537,418,150,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:480AM','Dec 8 2006 7:25:38:480AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663228,418,153,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:933PM','Dec 6 2006 3:11:54:933PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678309,418,153,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:840AM','Dec 8 2006 7:25:58:840AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663036,418,153,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:073PM','Dec 6 2006 3:11:49:073PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684689,418,153,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:603PM','Dec 7 2006 12:02:41:603PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677538,418,153,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:480AM','Dec 8 2006 7:25:38:480AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663229,418,156,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:933PM','Dec 6 2006 3:11:54:933PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678310,418,156,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:853AM','Dec 8 2006 7:25:58:853AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663037,418,156,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:090PM','Dec 6 2006 3:11:49:090PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684690,418,156,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:603PM','Dec 7 2006 12:02:41:603PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677539,418,156,1066.800,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:493AM','Dec 8 2006 7:25:38:493AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817718,418,156,1067.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 6:35:43:300PM','Jan 8 2007 6:35:43:300PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663230,418,159,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:933PM','Dec 6 2006 3:11:54:933PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678311,418,159,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:853AM','Dec 8 2006 7:25:58:853AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663038,418,159,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:090PM','Dec 6 2006 3:11:49:090PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684691,418,159,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:603PM','Dec 7 2006 12:02:41:603PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677540,418,159,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:493AM','Dec 8 2006 7:25:38:493AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663231,418,162,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:947PM','Dec 6 2006 3:11:54:947PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678312,418,162,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:853AM','Dec 8 2006 7:25:58:853AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663039,418,162,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:090PM','Dec 6 2006 3:11:49:090PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684692,418,162,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:620PM','Dec 7 2006 12:02:41:620PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677541,418,162,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:493AM','Dec 8 2006 7:25:38:493AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663232,418,165,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:947PM','Dec 6 2006 3:11:54:947PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678313,418,165,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:853AM','Dec 8 2006 7:25:58:853AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663040,418,165,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:090PM','Dec 6 2006 3:11:49:090PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684693,418,165,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:620PM','Dec 7 2006 12:02:41:620PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677542,418,165,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:493AM','Dec 8 2006 7:25:38:493AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663233,418,168,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:947PM','Dec 6 2006 3:11:54:947PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678314,418,168,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:870AM','Dec 8 2006 7:25:58:870AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663041,418,168,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:103PM','Dec 6 2006 3:11:49:103PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684694,418,168,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:620PM','Dec 7 2006 12:02:41:620PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677543,418,168,895.000,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:510AM','Dec 8 2006 7:25:38:510AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(816969,418,168,895.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 7:18:18:660PM','Jan 8 2007 7:18:18:660PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663234,418,171,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:947PM','Dec 6 2006 3:11:54:947PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678315,418,171,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:870AM','Dec 8 2006 7:25:58:870AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663042,418,171,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:103PM','Dec 6 2006 3:11:49:103PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684695,418,171,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:620PM','Dec 7 2006 12:02:41:620PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677544,418,171,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:510AM','Dec 8 2006 7:25:38:510AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663235,418,174,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:963PM','Dec 6 2006 3:11:54:963PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678316,418,174,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:870AM','Dec 8 2006 7:25:58:870AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663043,418,174,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:103PM','Dec 6 2006 3:11:49:103PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684696,418,174,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:637PM','Dec 7 2006 12:02:41:637PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677545,418,174,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:510AM','Dec 8 2006 7:25:38:510AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663236,418,177,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:963PM','Dec 6 2006 3:11:54:963PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678317,418,177,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:870AM','Dec 8 2006 7:25:58:870AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663044,418,177,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:103PM','Dec 6 2006 3:11:49:103PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684697,418,177,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:637PM','Dec 7 2006 12:02:41:637PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677546,418,177,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:510AM','Dec 8 2006 7:25:38:510AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663237,418,180,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:963PM','Dec 6 2006 3:11:54:963PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678318,418,180,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:887AM','Dec 8 2006 7:25:58:887AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663045,418,180,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:120PM','Dec 6 2006 3:11:49:120PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684698,418,180,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:637PM','Dec 7 2006 12:02:41:637PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677547,418,180,921.900,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:527AM','Dec 8 2006 7:25:38:527AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(816331,418,180,922.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 7:45:43:457PM','Jan 8 2007 7:45:43:457PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663238,418,183,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:963PM','Dec 6 2006 3:11:54:963PM','TSO1',1,NULL,1,6)

PRINT 'Done'

SET IDENTITY_INSERT [tbrValue] OFF
GO
SET NOCOUNT OFF

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 13:15:29

Sample Data (Part 4)

[CODE]
SET NOCOUNT ON

SET IDENTITY_INSERT [tbrValue] ON
GO

INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678319,418,183,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:887AM','Dec 8 2006 7:25:58:887AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663046,418,183,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:120PM','Dec 6 2006 3:11:49:120PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684699,418,183,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:637PM','Dec 7 2006 12:02:41:637PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677548,418,183,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:527AM','Dec 8 2006 7:25:38:527AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663239,418,186,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:980PM','Dec 6 2006 3:11:54:980PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678320,418,186,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:887AM','Dec 8 2006 7:25:58:887AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663047,418,186,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:120PM','Dec 6 2006 3:11:49:120PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684700,418,186,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:650PM','Dec 7 2006 12:02:41:650PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677549,418,186,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:527AM','Dec 8 2006 7:25:38:527AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663240,418,189,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:980PM','Dec 6 2006 3:11:54:980PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678321,418,189,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:887AM','Dec 8 2006 7:25:58:887AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663048,418,189,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:120PM','Dec 6 2006 3:11:49:120PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684701,418,189,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:650PM','Dec 7 2006 12:02:41:650PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677550,418,189,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:527AM','Dec 8 2006 7:25:38:527AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663241,418,192,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:980PM','Dec 6 2006 3:11:54:980PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678322,418,192,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:900AM','Dec 8 2006 7:25:58:900AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663049,418,192,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:137PM','Dec 6 2006 3:11:49:137PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684702,418,192,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:650PM','Dec 7 2006 12:02:41:650PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677551,418,192,1107.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:543AM','Dec 8 2006 7:25:38:543AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817504,418,192,1108.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 6:15:15:363PM','Jan 8 2007 6:15:15:363PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663242,418,195,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:993PM','Dec 6 2006 3:11:54:993PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678323,418,195,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:900AM','Dec 8 2006 7:25:58:900AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663050,418,195,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:137PM','Dec 6 2006 3:11:49:137PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684703,418,195,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:650PM','Dec 7 2006 12:02:41:650PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677552,418,195,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:543AM','Dec 8 2006 7:25:38:543AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663243,418,198,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:993PM','Dec 6 2006 3:11:54:993PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678324,418,198,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:900AM','Dec 8 2006 7:25:58:900AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663051,418,198,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:137PM','Dec 6 2006 3:11:49:137PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684704,418,198,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:667PM','Dec 7 2006 12:02:41:667PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677553,418,198,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:543AM','Dec 8 2006 7:25:38:543AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663244,418,201,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:993PM','Dec 6 2006 3:11:54:993PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678325,418,201,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:900AM','Dec 8 2006 7:25:58:900AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663052,418,201,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:137PM','Dec 6 2006 3:11:49:137PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684705,418,201,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:667PM','Dec 7 2006 12:02:41:667PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677554,418,201,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:543AM','Dec 8 2006 7:25:38:543AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663245,418,204,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:54:993PM','Dec 6 2006 3:11:54:993PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678326,418,204,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:917AM','Dec 8 2006 7:25:58:917AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663053,418,204,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:150PM','Dec 6 2006 3:11:49:150PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684706,418,204,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:667PM','Dec 7 2006 12:02:41:667PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677555,418,204,985.200,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:557AM','Dec 8 2006 7:25:38:557AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818200,418,204,985.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 6:57:23:597PM','Jan 8 2007 6:57:23:597PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663246,418,207,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:010PM','Dec 6 2006 3:11:55:010PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678327,418,207,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:917AM','Dec 8 2006 7:25:58:917AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663054,418,207,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:150PM','Dec 6 2006 3:11:49:150PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684707,418,207,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:667PM','Dec 7 2006 12:02:41:667PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677556,418,207,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:557AM','Dec 8 2006 7:25:38:557AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663247,418,210,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:010PM','Dec 6 2006 3:11:55:010PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678328,418,210,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:917AM','Dec 8 2006 7:25:58:917AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663055,418,210,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:150PM','Dec 6 2006 3:11:49:150PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684708,418,210,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:683PM','Dec 7 2006 12:02:41:683PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677557,418,210,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:557AM','Dec 8 2006 7:25:38:557AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663248,418,213,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:010PM','Dec 6 2006 3:11:55:010PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678329,418,213,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:917AM','Dec 8 2006 7:25:58:917AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663056,418,213,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:150PM','Dec 6 2006 3:11:49:150PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684709,418,213,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:683PM','Dec 7 2006 12:02:41:683PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677558,418,213,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:557AM','Dec 8 2006 7:25:38:557AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663249,418,216,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:010PM','Dec 6 2006 3:11:55:010PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678330,418,216,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:933AM','Dec 8 2006 7:25:58:933AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663057,418,216,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:167PM','Dec 6 2006 3:11:49:167PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684710,418,216,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:683PM','Dec 7 2006 12:02:41:683PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677559,418,216,616.500,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:573AM','Dec 8 2006 7:25:38:573AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818365,418,216,617.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 6:59:11:987PM','Jan 8 2007 6:59:11:987PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663250,418,219,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:027PM','Dec 6 2006 3:11:55:027PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678331,418,219,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:933AM','Dec 8 2006 7:25:58:933AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663058,418,219,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:167PM','Dec 6 2006 3:11:49:167PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684711,418,219,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:683PM','Dec 7 2006 12:02:41:683PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677560,418,219,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:573AM','Dec 8 2006 7:25:38:573AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663251,418,222,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:027PM','Dec 6 2006 3:11:55:027PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678332,418,222,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:933AM','Dec 8 2006 7:25:58:933AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663059,418,222,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:167PM','Dec 6 2006 3:11:49:167PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684712,418,222,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:697PM','Dec 7 2006 12:02:41:697PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677561,418,222,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:573AM','Dec 8 2006 7:25:38:573AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663252,418,225,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:027PM','Dec 6 2006 3:11:55:027PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678333,418,225,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:933AM','Dec 8 2006 7:25:58:933AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663060,418,225,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:167PM','Dec 6 2006 3:11:49:167PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684713,418,225,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:697PM','Dec 7 2006 12:02:41:697PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677562,418,225,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:573AM','Dec 8 2006 7:25:38:573AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663253,418,228,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:027PM','Dec 6 2006 3:11:55:027PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678334,418,228,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:947AM','Dec 8 2006 7:25:58:947AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663061,418,228,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:183PM','Dec 6 2006 3:11:49:183PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684714,418,228,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:697PM','Dec 7 2006 12:02:41:697PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677563,418,228,606.700,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:590AM','Dec 8 2006 7:25:38:590AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(818438,418,228,607.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 6:02:54:627PM','Jan 8 2007 6:02:54:627PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663254,418,231,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:043PM','Dec 6 2006 3:11:55:043PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678335,418,231,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:947AM','Dec 8 2006 7:25:58:947AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663062,418,231,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:183PM','Dec 6 2006 3:11:49:183PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684715,418,231,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:713PM','Dec 7 2006 12:02:41:713PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677564,418,231,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:590AM','Dec 8 2006 7:25:38:590AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663255,418,234,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:043PM','Dec 6 2006 3:11:55:043PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678336,418,234,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:947AM','Dec 8 2006 7:25:58:947AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663063,418,234,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:183PM','Dec 6 2006 3:11:49:183PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684716,418,234,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:713PM','Dec 7 2006 12:02:41:713PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677565,418,234,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:590AM','Dec 8 2006 7:25:38:590AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663256,418,237,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:043PM','Dec 6 2006 3:11:55:043PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678337,418,237,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:947AM','Dec 8 2006 7:25:58:947AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663064,418,237,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:197PM','Dec 6 2006 3:11:49:197PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684717,418,237,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:713PM','Dec 7 2006 12:02:41:713PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677566,418,237,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:603AM','Dec 8 2006 7:25:38:603AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663257,418,240,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:043PM','Dec 6 2006 3:11:55:043PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678338,418,240,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:963AM','Dec 8 2006 7:25:58:963AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663065,418,240,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:197PM','Dec 6 2006 3:11:49:197PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684718,418,240,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:713PM','Dec 7 2006 12:02:41:713PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677567,418,240,804.600,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:603AM','Dec 8 2006 7:25:38:603AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(817891,418,240,805.000,'Dec 7 2006 12:00:00:000AM',1,'Jan 8 2007 5:51:50:613PM','Jan 8 2007 5:51:50:613PM',NULL,0,NULL,1,40)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663258,418,243,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:057PM','Dec 6 2006 3:11:55:057PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678339,418,243,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:963AM','Dec 8 2006 7:25:58:963AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663066,418,243,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:197PM','Dec 6 2006 3:11:49:197PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684719,418,243,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:730PM','Dec 7 2006 12:02:41:730PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677568,418,243,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:603AM','Dec 8 2006 7:25:38:603AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663259,418,246,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:057PM','Dec 6 2006 3:11:55:057PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678340,418,246,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:963AM','Dec 8 2006 7:25:58:963AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663067,418,246,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:197PM','Dec 6 2006 3:11:49:197PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684720,418,246,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:730PM','Dec 7 2006 12:02:41:730PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677569,418,246,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:603AM','Dec 8 2006 7:25:38:603AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663260,418,249,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:057PM','Dec 6 2006 3:11:55:057PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678341,418,249,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:980AM','Dec 8 2006 7:25:58:980AM','TSO1',1,NULL,8,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663068,418,249,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:49:213PM','Dec 6 2006 3:11:49:213PM','TSO2',1,NULL,1,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(684721,418,249,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 7 2006 12:02:41:730PM','Dec 7 2006 12:02:41:730PM','TSO2',1,NULL,8,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(677570,418,249,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:38:620AM','Dec 8 2006 7:25:38:620AM','TSO2',1,NULL,10,27)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(663261,418,252,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 6 2006 3:11:55:057PM','Dec 6 2006 3:11:55:057PM','TSO1',1,NULL,1,6)
INSERT INTO [tbrValue] ([IdValue],[IdColumn],[IdTime],[NumValue],[DateValue],[Status],[CreationDate],[LastModificationDate],[LastModifiedBy],[IsDefault],[SortOrder],[Version],[IdTso])VALUES(678342,418,252,588.100,'Dec 7 2006 12:00:00:000AM',1,'Dec 8 2006 7:25:58:980AM','Dec 8 2006 7:25:58:980AM','TSO1',1,NULL,8,6)

PRINT 'Done'

SET IDENTITY_INSERT [tbrValue] OFF
GO
SET NOCOUNT OFF
[/CODE]

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 13:36:02

Sorry it's a bit long but it's a good basis for testing performance.

If we run the stored procedure with following parameters here is the ouput. Notice that the stored procedure always returns 24 records and that the values returned are the value with IdTso=40 which is the Tso with the lowest priority level (0).

The sample data from IdTso=40 only have one version (version=1). If another version would exists it would take the highest one.

I hope it can help someone to improve this stored procedure. I think the priority subquery is the one which takes the most time to run.

Kindly

Gilles

EXEC [GetValueByIdColumnDateIdTimeType] 418, '20061207', 2

Title         IdValue     IdColumn    IdTime      NumValue                                DateValue               Status      IdTso              Version
------------- ----------- ----------- ----------- --------------------------------------- ----------------------- ----------- ----------------   --------

00.00-01.00   816424      418         12          350.000                                 2006-12-07 00:00:00.000 1           40                 1
01.00-02.00   816901      418         24          291.000                                 2006-12-07 00:00:00.000 1           40                 1
02.00-03.00   818346      418         36          769.000                                 2006-12-07 00:00:00.000 1           40                 1
03.00-04.00   817520      418         48          878.000                                 2006-12-07 00:00:00.000 1           40                 1
04.00-05.00   818139      418         60          424.000                                 2006-12-07 00:00:00.000 1           40                 1
05.00-06.00   816105      418         72          0.000                                   2006-12-07 00:00:00.000 1           40                 1
06.00-07.00   817722      418         84          707.000                                 2006-12-07 00:00:00.000 1           40                 1
07.00-08.00   818029      418         96          703.000                                 2006-12-07 00:00:00.000 1           40                 1
08.00-09.00   817414      418         108         1095.000                                2006-12-07 00:00:00.000 1           40                 1
09.00-10.00   818266      418         120         1080.000                                2006-12-07 00:00:00.000 1           40                 1
10.00-11.00   817264      418         132         1039.000                                2006-12-07 00:00:00.000 1           40                 1
11.00-12.00   817800      418         144         1083.000                                2006-12-07 00:00:00.000 1           40                 1
12.00-13.00   817718      418         156         1067.000                                2006-12-07 00:00:00.000 1           40                 1
13.00-14.00   816969      418         168         895.000                                 2006-12-07 00:00:00.000 1           40                 1
14.00-15.00   816331      418         180         922.000                                 2006-12-07 00:00:00.000 1           40                 1
15.00-16.00   817504      418         192         1108.000                                2006-12-07 00:00:00.000 1           40                 1
16.00-17.00   818200      418         204         985.000                                 2006-12-07 00:00:00.000 1           40                 1
17.00-18.00   818365      418         216         617.000                                 2006-12-07 00:00:00.000 1           40                 1
18.00-19.00   818438      418         228         607.000                                 2006-12-07 00:00:00.000 1           40                 1
19.00-20.00   817891      418         240         805.000                                 2006-12-07 00:00:00.000 1           40                 1
20.00-21.00   818161      418         252         588.000                                 2006-12-07 00:00:00.000 1           40                 1
21.00-22.00   816788      418         264         363.000                                 2006-12-07 00:00:00.000 1           40                 1
22.00-23.00   818308      418         276         126.000                                 2006-12-07 00:00:00.000 1           40                 1
23.00-00.00   818226      418         288         406.000                                 2006-12-07 00:00:00.000 1           40                 1

(24 row(s) affected)

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-01-22 : 13:58:00

A quick thing I noticed right away: You have this expression (or a variation) repeated quite a bit:

dbo.DateTimeToDateOnly(Val.DateValue) = dbo.DateTimeToDateOnly(@DateValue)

First, you should re-assign @DateValue to be the Date only value in the beginning, instead of doing it over and over and over:

set @DateValue = dbo.DateTimeToDateOnly(@DateValue)

A minor thing, but it will make your code more readable and save a little bit of time.

Next, I did not see any indexes on your tables. Your date columns should definitely be indexed, otherwise table scans are necessary.

However, just indexing that date column alone won't do the trick since wrapping it in a DateTimeToDateOnly() function each time you reference it in a join or WHERE clause eliminates the ability to use indexes. You should replace that with a simple range join on a single day. thus, your many instances of this type of expression:

dbo.DateTimeToDateOnly(Val.DateValue) = dbo.DateTimeToDateOnly(@DateValue)

should become instead:

Val.DateValue >= @DateValue and Val.DateValue < (@DateValue + 1)

that's just some quick observations. It appears that your joins and subselects could use a complete rewrite, but that will take more time to analyze, if I get a chance I will take a look ...

- Jeff

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-01-22 : 14:02:00

Also: replace your DateOnly function with the one found here:

http://weblogs.sqlteam.com/jeffs/archive/2007/01/02/56079.aspx

That technique is shorter and has been proven to be more efficient rather than doing all sorts of Converts to strip times from dates. Plus, it is more accurate and not susceptible to rounding errors.

- Jeff

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 14:17:56

Thany you Jeff, I will change the DateOnly function with yours and store my @date variable to calculate it only once.

You said that if I use a function to wrap the DateValue field the indexes aren't used. I think I can ensure that the DateValue values are inserted and updated without time informations during inserts and updates if it can improve performance.

For the indexes I have some on the productive Database but I thought it would be better to remove them to see performance differences. I can post them if it helps.

Gilles

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-01-22 : 14:23:33

that would be a huge increase in performance if you can insert data without times. You can still store the time itself in another column if you need it. Once again, I'll refer you to my blog:

http://weblogs.sqlteam.com/jeffs/archive/2004/12/02/2954.aspx

If you can write:

WHERE DateCol = @SomeDate

and DateCol is indexed, that will be much, much, much faster than using a function, and quite a bit faster than using a date range as well. you should see quite a performance increase just by doing that alone.

- Jeff

faesgill
Starting Member

9 Posts

Posted - 2007-01-22 : 14:35:33

You are right, It's an huge improvement to avoid the DateOnly Function.

I just made a test on our production server which has a lot more data to compare performance.

CODE :

SET STATISTICS TIME ON
EXEC [GetValueByIdColumnDateIdTimeTypeVersion1] 418, '20061207', 2
SET STATISTICS TIME OFF;
GO
SET STATISTICS TIME ON
EXEC [GetValueByIdColumnDateIdTimeTypeVersion2] 418, '20061207', 2
SET STATISTICS TIME OFF;
GO

Procedure version 1 (using DateOnly functions)
SQL Server Execution Times:
CPU time = 7110 ms, elapsed time = 7336 ms.
SQL Server Execution Times:
CPU time = 7110 ms, elapsed time = 7337 ms.

Procedure version 2 (without DateOnly functions "WHERE DateCol = @SomeDate")
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 6 ms.
SQL Server Execution Times:
CPU time = 31 ms, elapsed time = 31 ms.

Seems my problem is already almost solved. I will do some in depth tests.

For the indexes I create some manually and other trough the SQL Profiler analyzing the stored procedure code. I think I have to remove all of them because of the code modification and recreate them from scratch ?

Kindly

Gilles

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-01-22 : 16:46:46

it doesn't matter how you create them, as long as they are there and on the correct columns.

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources