Help for joining tables (2nd try ;o) )

Okay so I'll give it another try
I have an assigment design a web solution with a presention of energy
consumptions from some appartments.
All appartments are identical and have 5 meters, the only difference is the
appartment number (3 digits) e.g. "105" all meters gets logged once every
night at 02.00 AM.
My idea is to work with a collection of "predefined" meters e.g. and join
them with the logged data, that's why I have the meters table, then I can
also add additional meters without changeing code.
The consumption presentation is done per appartment, meaning that the owner
of the appartment logs on to the system and the appartment ID gets
identified e.g. 105. When the owner has logged on the energy data for the
related appartment will be presented.
I have three tables
Meters m (defined by me)
Analog register (defined by the log system)
Analog values (defined by the log system)
the relation between analog values is the field "ID" PK in Analog Register
AR, FK in Analog Values AV
this script joins and summerize the energy data, so far so good!
Select ar.[name], av.id, count(*) as NoOfLogs,
Sum(Case WHEN Datediff(Mi, timedate, getdate()) < 60 THEN av.Val ELSE 0
END) as [Last Hour],
Sum(av.val) as Total
From [Analog register] AR INNER JOIN [analog values] AV
On AR.[ID] = AV.[ID]
--where ar.[name] in (select [name] from meters m where type = 1)
GROUP by ar.[name], av.id
select * from meters
--where ar.[name] in (select [name] from meters m where type = 1)
The where caluse is the part I try to replace with something like
"where meters.name+@.appartmentnumber like ar.name"
What I need is to see if meters.name plus the appartmendnumber is a
substring of ar.name.
With the above "where clause" it only works if there's an exact match.
@.appartmentnumber is a variable I add to the query.
I hope this makes my needs more clear'
regards
Henry
****** DDL
CREATE TABLE [dbo].[Meters] (
[Meter_id] uniqueidentifier ROWGUIDCOL NOT NULL ,
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [int] NULL ,
[Unit] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Designation] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('0DA234BA-12AA-43E6-B94C-004F265F82D8','Solfanger',2,
'kwh','Solenergi')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('EDC2D54C-704D-4DE3-AFB2-1A2584BFB077','And',1,'Kwh',
'Energi')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('F3C42A01-098C-48F8-A4D3-2F4F120AE597','Anders',1,'Mw
h','Elmler')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('0A4FF86E-0F66-44FB-8022-B9FC90630F22','X5991_P07_inp
ut_Accum',1,'m3','Gas-mler')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('046B8001-795D-4C61-8B45-CA9B3BB02EEF','X5991_P06_inp
ut_Accum',1,'m3','Varmtvandsmler')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('0DBE4542-F741-4D60-A9B1-DAE4DA69AD10','X5991_P04_inp
ut_Accum',1,'Kwh','El-mler')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('20C1A7CB-041E-47E0-B0C7-DD7F54C6CC41','SupplyTemp.Ma
x',1,'m3','Testmler1')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('A8E1FA35-225C-414D-849C-F5256D2A2845','ReturnTemp',1
,'kwh','Testmler2')
INSERT INTO [meters]
([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('FDDE06DB-E501-4748-A514-FCB9B99594C4','X5991_P05_inp
ut_Accum',1,'m3','Koldtvandsmler')
CREATE TABLE [dbo].[Analog Register] (
[Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ID] [int] NOT NULL ,
[Category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Area] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [smallint] NOT NULL ,
[Val] [float] NULL ,
[ValueTime] [datetime] NULL ,
[MinValue] [float] NULL ,
[MaxValue] [real] NULL ,
[SignalText] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SigType] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Unit] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Description] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MaxRawTimeLength] [int] NULL ,
[CompactTimeLength0] [int] NULL ,
[CompactTime0] [datetime] NULL ,
[CompactVal0] [float] NULL ,
[CompactFlags0] [real] NULL ,
[CompactTimeLength1] [int] NULL ,
[CompactTime1] [datetime] NULL ,
[CompactVal1] [float] NULL ,
[CompactFlags1] [real] NULL ,
[CompactTimeLength2] [int] NULL ,
[CompactTime2] [datetime] NULL ,
[CompactVal2] [float] NULL ,
[CompactFlags2] [real] NULL ,
[CompactTimeLength3] [int] NULL ,
[CompactTime3] [datetime] NULL ,
[CompactVal3] [float] NULL ,
[CompactFlags3] [real] NULL
) ON [PRIMARY]
GO
INSERT INTO [Analog Register]
([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. OutdoorTemp',1,'LogSignals','Library2',1
,-1.042895
793914795e+000,'Jun
7 2006 12:00:00:000AM','Mler1')
INSERT INTO [Analog Register]
([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. SupplyTemp',2,'LogSignals','Library2',1,
6.07073631
2866211e+001,'Jun
7 2006 12:00:00:000AM','Mler2')
INSERT INTO [Analog Register]
([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. SupplyTempControl_SetP',3,'LogSignals','
Library2',
1,7.500000000000000e+001,'Jun
7 2006 12:00:00:000AM','Mler3')
INSERT INTO [Analog Register]
([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. ReturnTemp',4,'LogSignals','Library2',1,
2.83133945
4650879e+001,'Jun
7 2006 12:00:00:000AM','Mler4')
INSERT INTO [Analog Register]
([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2.SupplyTemp.Max',5,'LogSignals','Library2',3,6.0707
56912231445e+001,'Jun
6 2006 12:00:00:000AM','Mler5')
I had to ommit some of the irelevant data from the AR table.
CREATE TABLE [dbo].[Analog Values] (
[ID] [int] NOT NULL ,
[TimeDate] [datetime] NOT NULL ,
[TimeLength] [int] NULL ,
[Flags] [int] NULL ,
[Val] [float] NULL ,
[Count] [int] NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [Analog values] VALUES(1,'Jun 23 2006
5:49:00:903PM',3600,1,1.910181823780489e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 23 2006
5:49:00:903PM',3600,1,1.910181823780489e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 23 2006
5:49:00:903PM',3600,1,1.910181823780489e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 23 2006
5:49:00:903PM',3600,1,1.910181823780489e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
5:52:00:560PM',3600,1,1.903790714638927e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 23 2006
5:53:00:560PM',3600,1,1.903790714638927e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 23 2006
5:53:00:560PM',3600,1,1.903790714638927e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 23 2006
5:53:00:560PM',3600,1,1.903790714638927e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 23 2006
5:53:00:560PM',3600,1,1.903790714638927e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
5:53:00:560PM',3600,1,1.903790714638927e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 23 2006
7:34:00:547PM',3600,1,1.903548486012570e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 23 2006
7:34:00:750PM',3600,1,3.907330979177984e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
7:34:00:983PM',3600,1,5.911672461481145e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 23 2006
7:36:00:653PM',3600,1,2.905523580965939e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 23 2006
7:36:00:827PM',3600,1,4.908765717964866e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
7:36:00:903PM',3600,1,5.910181823780489e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 24 2006
12:06:00:857AM',3600,1,1.909324707102612e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 24 2006
12:06:00:920AM',3600,1,2.910498584291879e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 24 2006
12:06:00:997AM',3600,1,3.911933323078760e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 24 2006
12:06:01:043AM',3600,1,4.912790439756638e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 24 2006
12:06:01:090AM',3600,1,5.913666189405772e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 25 2006
2:23:00:140AM',3600,1,1.895964866710483e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 25 2006
2:23:00:263AM',3600,1,3.898256722175241e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 25 2006
2:23:00:373AM',3600,1,5.900306349013643e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 25 2006
2:24:00:200AM',3600,1,2.897082844985975e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 25 2006
2:24:00:327AM',3600,1,4.899449232335766e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 25 2006
2:26:00:140AM',3600,1,1.895964866710483e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 25 2006
2:26:00:200AM',3600,1,2.897082844985975e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 25 2006
2:26:00:263AM',3600,1,3.898256722175241e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 25 2006
2:26:00:327AM',3600,1,4.899449232335766e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 25 2006
2:26:00:390AM',3600,1,5.900623109525032e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 26 2006
1:08:00:687AM',3600,1,1.906157101988718e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 26 2006
1:08:00:763AM',3600,1,2.907573207804341e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
1:08:00:840AM',3600,1,3.909007946591222e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 26 2006
1:08:00:950AM',3600,1,4.911057573429624e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 26 2006
1:08:01:030AM',3600,1,5.912548211130281e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 26 2006
1:09:00:670AM',3600,1,1.905840341477328e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
1:09:00:797AM',3600,1,3.908206728827120e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 26 2006
1:09:00:920AM',3600,1,5.910498584291879e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 26 2006
1:10:00:733AM',3600,1,2.907014218666595e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
1:10:00:797AM',3600,1,3.908206728827120e+000,1)
INSERT INTO [Analog values] VALUES(1,'Jun 26 2006
6:27:00:687AM',3600,1,1.906157101988718e+000,1)
INSERT INTO [Analog values] VALUES(2,'Jun 26 2006
6:27:00:747AM',3600,1,2.907275080264210e+000,1)
INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
6:27:00:810AM',3600,1,3.908448957453476e+000,1)
INSERT INTO [Analog values] VALUES(4,'Jun 26 2006
6:27:00:873AM',3600,1,4.909622834642743e+000,1)
INSERT INTO [Analog values] VALUES(5,'Jun 26 2006
6:27:00:937AM',3600,1,5.910815344803268e+000,1)Henry,

> What I need is to see if meters.name plus the appartmendnumber is a
> substring of ar.name.
...
where ar.name like '%' + meters.name + @.appartmentnumber + '%'
AMB
meters.name+@.appartmentnumber like
"Henry" wrote:

> Okay so I'll give it another try
> I have an assigment design a web solution with a presention of energy
> consumptions from some appartments.
> All appartments are identical and have 5 meters, the only difference is th
e
> appartment number (3 digits) e.g. "105" all meters gets logged once every
> night at 02.00 AM.
> My idea is to work with a collection of "predefined" meters e.g. and join
> them with the logged data, that's why I have the meters table, then I can
> also add additional meters without changeing code.
> The consumption presentation is done per appartment, meaning that the owne
r
> of the appartment logs on to the system and the appartment ID gets
> identified e.g. 105. When the owner has logged on the energy data for the
> related appartment will be presented.
> I have three tables
> Meters m (defined by me)
> Analog register (defined by the log system)
> Analog values (defined by the log system)
> the relation between analog values is the field "ID" PK in Analog Register
> AR, FK in Analog Values AV
> this script joins and summerize the energy data, so far so good!
> Select ar.[name], av.id, count(*) as NoOfLogs,
> Sum(Case WHEN Datediff(Mi, timedate, getdate()) < 60 THEN av.Val ELSE 0
> END) as [Last Hour],
> Sum(av.val) as Total
> From [Analog register] AR INNER JOIN [analog values] AV
> On AR.[ID] = AV.[ID]
> --where ar.[name] in (select [name] from meters m where type = 1)
> GROUP by ar.[name], av.id
> select * from meters
> --where ar.[name] in (select [name] from meters m where type = 1)
> The where caluse is the part I try to replace with something like
> "where meters.name+@.appartmentnumber like ar.name"
> What I need is to see if meters.name plus the appartmendnumber is a
> substring of ar.name.
> With the above "where clause" it only works if there's an exact match.
> @.appartmentnumber is a variable I add to the query.
> I hope this makes my needs more clear'
>
> regards
> Henry
>
> ****** DDL
>
> CREATE TABLE [dbo].[Meters] (
> [Meter_id] uniqueidentifier ROWGUIDCOL NOT NULL ,
> [Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [Type] [int] NULL ,
> [Unit] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [Designation] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
> ) ON [PRIMARY]
> GO
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('0DA234BA-12AA-43E6-B94C-004F265F82D8','Solfanger',
2,'kwh','Solenergi')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('EDC2D54C-704D-4DE3-AFB2-1A2584BFB077','And',1,'Kwh
','Energi')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('F3C42A01-098C-48F8-A4D3-2F4F120AE597','Anders',1,'
Mwh','Elmler')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('0A4FF86E-0F66-44FB-8022-B9FC90630F22','X5991_P07_i
nput_Accum',1,'m3','Gas-mler')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('046B8001-795D-4C61-8B45-CA9B3BB02EEF','X5991_P06_i
nput_Accum',1,'m3','Varmtvandsmler')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('0DBE4542-F741-4D60-A9B1-DAE4DA69AD10','X5991_P04_i
nput_Accum',1,'Kwh','El-mler')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('20C1A7CB-041E-47E0-B0C7-DD7F54C6CC41','SupplyTemp.
Max',1,'m3','Testmler1')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('A8E1FA35-225C-414D-849C-F5256D2A2845','ReturnTemp'
,1,'kwh','Testmler2')
> INSERT INTO [meters]
> ([Meter_id],[Name],[Type],[Unit],[Design
ation])VALUES('FDDE06DB-E501-4748-A514-FCB9B99594C4','X5991_P05_i
nput_Accum',1,'m3','Koldtvandsmler')
>
> CREATE TABLE [dbo].[Analog Register] (
> [Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [ID] [int] NOT NULL ,
> [Category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [Area] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [Type] [smallint] NOT NULL ,
> [Val] [float] NULL ,
> [ValueTime] [datetime] NULL ,
> [MinValue] [float] NULL ,
> [MaxValue] [real] NULL ,
> [SignalText] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [SigType] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [Unit] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [Description] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> [MaxRawTimeLength] [int] NULL ,
> [CompactTimeLength0] [int] NULL ,
> [CompactTime0] [datetime] NULL ,
> [CompactVal0] [float] NULL ,
> [CompactFlags0] [real] NULL ,
> [CompactTimeLength1] [int] NULL ,
> [CompactTime1] [datetime] NULL ,
> [CompactVal1] [float] NULL ,
> [CompactFlags1] [real] NULL ,
> [CompactTimeLength2] [int] NULL ,
> [CompactTime2] [datetime] NULL ,
> [CompactVal2] [float] NULL ,
> [CompactFlags2] [real] NULL ,
> [CompactTimeLength3] [int] NULL ,
> [CompactTime3] [datetime] NULL ,
> [CompactVal3] [float] NULL ,
> [CompactFlags3] [real] NULL
> ) ON [PRIMARY]
> GO
> INSERT INTO [Analog Register]
> ([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. OutdoorTemp',1,'LogSignals','Library2',1
,-1.0428
95793914795e+000,'Jun
> 7 2006 12:00:00:000AM','Mler1')
> INSERT INTO [Analog Register]
> ([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. SupplyTemp',2,'LogSignals','Library2',1,
6.070736
312866211e+001,'Jun
> 7 2006 12:00:00:000AM','Mler2')
> INSERT INTO [Analog Register]
> ([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. SupplyTempControl_SetP',3,'LogSignals','
Library2
',1,7.500000000000000e+001,'Jun
> 7 2006 12:00:00:000AM','Mler3')
> INSERT INTO [Analog Register]
> ([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2. ReturnTemp',4,'LogSignals','Library2',1,
2.831339
454650879e+001,'Jun
> 7 2006 12:00:00:000AM','Mler4')
> INSERT INTO [Analog Register]
> ([Name],[ID],[Category],[Area],[Type],[V
al],[ValueTime],[SignalText])VALUES('Lib
rary2.SupplyTemp.Max',5,'LogSignals','Library2',3,6.07
0756912231445e+001,'Jun
> 6 2006 12:00:00:000AM','Mler5')
> I had to ommit some of the irelevant data from the AR table.
>
> CREATE TABLE [dbo].[Analog Values] (
> [ID] [int] NOT NULL ,
> [TimeDate] [datetime] NOT NULL ,
> [TimeLength] [int] NULL ,
> [Flags] [int] NULL ,
> [Val] [float] NULL ,
> [Count] [int] NOT NULL
> ) ON [PRIMARY]
> GO
> INSERT INTO [Analog values] VALUES(1,'Jun 23 2006
> 5:49:00:903PM',3600,1,1.910181823780489e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 23 2006
> 5:49:00:903PM',3600,1,1.910181823780489e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 23 2006
> 5:49:00:903PM',3600,1,1.910181823780489e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 23 2006
> 5:49:00:903PM',3600,1,1.910181823780489e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
> 5:52:00:560PM',3600,1,1.903790714638927e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 23 2006
> 5:53:00:560PM',3600,1,1.903790714638927e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 23 2006
> 5:53:00:560PM',3600,1,1.903790714638927e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 23 2006
> 5:53:00:560PM',3600,1,1.903790714638927e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 23 2006
> 5:53:00:560PM',3600,1,1.903790714638927e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
> 5:53:00:560PM',3600,1,1.903790714638927e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 23 2006
> 7:34:00:547PM',3600,1,1.903548486012570e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 23 2006
> 7:34:00:750PM',3600,1,3.907330979177984e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
> 7:34:00:983PM',3600,1,5.911672461481145e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 23 2006
> 7:36:00:653PM',3600,1,2.905523580965939e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 23 2006
> 7:36:00:827PM',3600,1,4.908765717964866e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 23 2006
> 7:36:00:903PM',3600,1,5.910181823780489e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 24 2006
> 12:06:00:857AM',3600,1,1.909324707102612e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 24 2006
> 12:06:00:920AM',3600,1,2.910498584291879e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 24 2006
> 12:06:00:997AM',3600,1,3.911933323078760e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 24 2006
> 12:06:01:043AM',3600,1,4.912790439756638e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 24 2006
> 12:06:01:090AM',3600,1,5.913666189405772e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 25 2006
> 2:23:00:140AM',3600,1,1.895964866710483e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 25 2006
> 2:23:00:263AM',3600,1,3.898256722175241e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 25 2006
> 2:23:00:373AM',3600,1,5.900306349013643e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 25 2006
> 2:24:00:200AM',3600,1,2.897082844985975e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 25 2006
> 2:24:00:327AM',3600,1,4.899449232335766e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 25 2006
> 2:26:00:140AM',3600,1,1.895964866710483e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 25 2006
> 2:26:00:200AM',3600,1,2.897082844985975e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 25 2006
> 2:26:00:263AM',3600,1,3.898256722175241e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 25 2006
> 2:26:00:327AM',3600,1,4.899449232335766e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 25 2006
> 2:26:00:390AM',3600,1,5.900623109525032e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 26 2006
> 1:08:00:687AM',3600,1,1.906157101988718e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 26 2006
> 1:08:00:763AM',3600,1,2.907573207804341e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
> 1:08:00:840AM',3600,1,3.909007946591222e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 26 2006
> 1:08:00:950AM',3600,1,4.911057573429624e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 26 2006
> 1:08:01:030AM',3600,1,5.912548211130281e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 26 2006
> 1:09:00:670AM',3600,1,1.905840341477328e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
> 1:09:00:797AM',3600,1,3.908206728827120e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 26 2006
> 1:09:00:920AM',3600,1,5.910498584291879e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 26 2006
> 1:10:00:733AM',3600,1,2.907014218666595e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
> 1:10:00:797AM',3600,1,3.908206728827120e+000,1)
> INSERT INTO [Analog values] VALUES(1,'Jun 26 2006
> 6:27:00:687AM',3600,1,1.906157101988718e+000,1)
> INSERT INTO [Analog values] VALUES(2,'Jun 26 2006
> 6:27:00:747AM',3600,1,2.907275080264210e+000,1)
> INSERT INTO [Analog values] VALUES(3,'Jun 26 2006
> 6:27:00:810AM',3600,1,3.908448957453476e+000,1)
> INSERT INTO [Analog values] VALUES(4,'Jun 26 2006
> 6:27:00:873AM',3600,1,4.909622834642743e+000,1)
> INSERT INTO [Analog values] VALUES(5,'Jun 26 2006
> 6:27:00:937AM',3600,1,5.910815344803268e+000,1)
>
>sql