Однако, если по какой-то причине вы должны использовать составной первичный ключ в этих трех полях, то вот код для этого.
ПРИМЕЧАНИЕ. Вы не можете просто добавить какое-то уникальное число к каждой дате, потому что вы можете дойти до точки, когда вы сделали так много односекундных приращений, что это фактически конфликтует с другим значением, которое вы встречаете в таблице. Это причина для части EXISTS кода.
drop table [constants_temp]
go
drop table [constants_new]
go
create table [constants_temp] (
inst_id varchar(25),
cons_code varchar(10),
eff_date_time datetime
)
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
-- Create a table with the idential structure as [constants_temp], except with the composite primary key on all three fields
create table [constants_new] (
inst_id varchar(25),
cons_code varchar(10),
eff_date_time datetime,
PRIMARY KEY (inst_id, cons_code, eff_date_time)
)
-- Variables to hold the column values from each row in the cursor
DECLARE @Cur_inst_id VARCHAR(25)
DECLARE @Cur_cons_code VARCHAR(10)
DECLARE @Cur_eff_date_time DATETIME
-- Go through all of the records in the [constants_temp] table
DECLARE BumpDate_Cursor CURSOR FOR
SELECT inst_id,
cons_code,
eff_date_time
FROM [constants_temp]
ORDER BY inst_id, cons_code, eff_date_time
-- Open the cursor and get the first record
OPEN BumpDate_Cursor
FETCH NEXT FROM BumpDate_Cursor INTO @Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time
-- For all the the records in the cursor...
WHILE @@FETCH_STATUS = 0
BEGIN
-- While there is already a record with a matching institution code, cons code, and effective date...
WHILE EXISTS (SELECT inst_id
FROM [constants_new]
WHERE inst_id = @Cur_inst_id and
cons_code = @Cur_cons_code and
eff_date_time = @Cur_eff_date_time)
BEGIN
-- Keep incrementing the effective date by one second
set @Cur_eff_date_time = DATEADD(second, 1, @Cur_eff_date_time)
END
-- Insert the new unique row
INSERT INTO [constants_new] (inst_id, cons_code, eff_date_time) VALUES (@Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time)
-- Get the next record in the cursor
FETCH NEXT FROM BumpDate_Cursor INTO @Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time
END
-- Close and deallocate the cursor
CLOSE BumpDate_Cursor
DEALLOCATE BumpDate_Cursor
-- Show the results
select * from [constants_new] order by inst_id, cons_code, eff_date_time
правильно, вам нужно посмотреть lv_count и посмотреть, какое значение оно содержит. Что вы видите как ошибку? Вы запустили sql profiler/debug, в чем может быть проблема.
Вы уверены, что он не работает?
drop table [constants_temp]
go
drop table [constants_new]
go
create table [constants_temp] (
inst_id varchar(25),
cons_code varchar(10),
eff_date_time datetime
)
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
-- Create a table with the idential structure as [constants_temp], except with the composite primary key on all three fields
create table [constants_new] (
inst_id varchar(25),
cons_code varchar(10),
eff_date_time datetime,
PRIMARY KEY (inst_id, cons_code, eff_date_time)
)
-- Variables to hold the column values from each row in the cursor
DECLARE @Cur_inst_id VARCHAR(25)
DECLARE @Cur_cons_code VARCHAR(10)
DECLARE @Cur_eff_date_time DATETIME
-- Go through all of the records in the [constants_temp] table
DECLARE BumpDate_Cursor CURSOR FOR
SELECT inst_id,
cons_code,
eff_date_time
FROM [constants_temp]
ORDER BY inst_id, cons_code, eff_date_time
-- Open the cursor and get the first record
OPEN BumpDate_Cursor
FETCH NEXT FROM BumpDate_Cursor INTO @Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time
-- For all the the records in the cursor...
WHILE @@FETCH_STATUS = 0
BEGIN
-- While there is already a record with a matching institution code, cons code, and effective date...
WHILE EXISTS (SELECT inst_id
FROM [constants_new]
WHERE inst_id = @Cur_inst_id and
cons_code = @Cur_cons_code and
eff_date_time = @Cur_eff_date_time)
BEGIN
-- Keep incrementing the effective date by one second
set @Cur_eff_date_time = DATEADD(second, 1, @Cur_eff_date_time)
END
-- Insert the new unique row
INSERT INTO [constants_new] (inst_id, cons_code, eff_date_time) VALUES (@Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time)
-- Get the next record in the cursor
FETCH NEXT FROM BumpDate_Cursor INTO @Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time
END
-- Close and deallocate the cursor
CLOSE BumpDate_Cursor
DEALLOCATE BumpDate_Cursor
-- Show the results
select * from [constants_new] order by inst_id, cons_code, eff_date_time
после того, как ваш _2_ все равно будет печатать значение, захваченное в _3_, а не текущее значение в строке таблицы.
drop table [constants_temp]
go
drop table [constants_new]
go
create table [constants_temp] (
inst_id varchar(25),
cons_code varchar(10),
eff_date_time datetime
)
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('1', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('2', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('3', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('4', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A', 'PU', '1901-01-01 17:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-1', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-10', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-11', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
insert into [constants_temp] (inst_id, cons_code, eff_date_time) values ('A-12', 'AS', '1972-07-01 00:00:00.000')
-- Create a table with the idential structure as [constants_temp], except with the composite primary key on all three fields
create table [constants_new] (
inst_id varchar(25),
cons_code varchar(10),
eff_date_time datetime,
PRIMARY KEY (inst_id, cons_code, eff_date_time)
)
-- Variables to hold the column values from each row in the cursor
DECLARE @Cur_inst_id VARCHAR(25)
DECLARE @Cur_cons_code VARCHAR(10)
DECLARE @Cur_eff_date_time DATETIME
-- Go through all of the records in the [constants_temp] table
DECLARE BumpDate_Cursor CURSOR FOR
SELECT inst_id,
cons_code,
eff_date_time
FROM [constants_temp]
ORDER BY inst_id, cons_code, eff_date_time
-- Open the cursor and get the first record
OPEN BumpDate_Cursor
FETCH NEXT FROM BumpDate_Cursor INTO @Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time
-- For all the the records in the cursor...
WHILE @@FETCH_STATUS = 0
BEGIN
-- While there is already a record with a matching institution code, cons code, and effective date...
WHILE EXISTS (SELECT inst_id
FROM [constants_new]
WHERE inst_id = @Cur_inst_id and
cons_code = @Cur_cons_code and
eff_date_time = @Cur_eff_date_time)
BEGIN
-- Keep incrementing the effective date by one second
set @Cur_eff_date_time = DATEADD(second, 1, @Cur_eff_date_time)
END
-- Insert the new unique row
INSERT INTO [constants_new] (inst_id, cons_code, eff_date_time) VALUES (@Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time)
-- Get the next record in the cursor
FETCH NEXT FROM BumpDate_Cursor INTO @Cur_inst_id, @Cur_cons_code, @Cur_eff_date_time
END
-- Close and deallocate the cursor
CLOSE BumpDate_Cursor
DEALLOCATE BumpDate_Cursor
-- Show the results
select * from [constants_new] order by inst_id, cons_code, eff_date_time
person
AR15Dude
schedule
31.08.2012
1 PU 1901-01-01 17:00:00.000 833,2 dba 2012-08-02 11:07:33.770 NULL NULL
1 PU 1901-01-01 17:00:00.000 821,6 дБА 02.08.2012 11:07:33.770 NULL NULL
1 PU 1901-01-01 17:00:00.000 8 дБA 2012- 08-02 11:07:33.770 NULL NULL
1 PU 1901-01-01 17:00:00.000 2251 дБА 2012-08-02 11:07:33.770 NULL NULL
2 PU 1901-01-01 17 :00:00.000 2251 дБА 02.08.2012 11:07:33.770 NULL NULL
2 PU 1901-01-01 17:00:00.000 22 дБА 02.08.2012 11:07:33.770 NULL NULL
2 PU 1901-01-01 17:00:00.000 820,9 дБА 02-08-2012 11:07:33.773 NULL NULL
07:33.773 NULL NULL
3 PU 1901-01-01 17:00:00.000 833.2 dba 02-08-2012 11:07:33.773 NULL NULL
3 PU 1901-01-01 17:00:00.000 821.5 dba 02-08-2012 11:07:33.773 NULL NULL
3 PU 1901-01 -01 17:00:00.000 8 dba 02-08-2012 11:07:33.773 NULL NULL
3 PU 1901-01-01 17:00:00.000 2095 dba 02-08-2012 11:07:33.773 NULL NULL
4 PU 1901-01-01 17:00:00.000 2095 dba 02.08.2012 11:07:33.777 NULL NULL
4 PU 1901-01-01 17:00:00.000 22 dba 2012-08- 02 11:07:33.777 NULL NULL
4 PU 1901-01-01 17:00:00.000 820,5 дБА 02.08.2012 11:07:33.777 NULL NULL
4 PU 1901-01-01 17:00 :00.000 833,2 дБА 02-08-2012 11:07:33.777 NULL NULL
A PU 1901-01-01 17:00:00.000 833,2 дБA 02-08-2012 11:07:33.777 NULL NULL
A PU 1901-01-01 17:00:00.000 816,8 дБА 02.08.2012 11:07:33.777 NULL NULL
A PU 1901-01-01 17:00:00.000 120,5 дБА 02-08-2012 11:07: 33 .780 NULL NULL
A PU 1901-01-01 17:00:00.000 2255 дБА 02-08-2012 11:07:33.780 NULL NULL
A-1 AS 1972-07-01 00:00:00.000 1492 дБА 02.08.2012 11:07:33.780 NULL NULL
A-1 AS 1972-07-01 00:00:00.000 986.48 дБА 02.08.2012 11:07:33.780 NULL NULL
A- 1 AS 1972-07-01 00:00:00.000 0 dba 02-08-2012 11:07:33.780 NULL NULL
A-10 AS 1972-07-01 00:00:00.000 0 dba 02-08-2012 11:07:33. 780 NULL NULL
A-10 AS 1972-07-01 00:00:00.000 986,48 дБА 02.08.2012 11:07:33.780 NULL NULL
A-10 AS 1972-07-01 00:00: 00.000 1857 дБА 02-08-2012 11:07:33.780 NULL NULL
A-11 AS 1972-07-01 00:00:00.000 1896 дБА 02-08-2012 11:07:33.783 NULL NULL
A -11 AS 1972-07-01 00:00:00.000 986,5 дБА 02.08.2012 11:07:33.783 NULL NULL
A-11 AS 1972-07-01 00:00:00.000 0 дБА 2012-08- 02 11:07:33.783 NULL NULL
A-12 AS 1972-07-01 00:00:00.000 0 dba 2012-08-02 11:07:33.783 NULL NULL
A-12 AS 1972-07- 01 00:00:00.000 986,5 дБА 02.08.2012 11:07:33.783 NULL NULL
A-12 AS 1972-07-01 00:00:00.000 1936 дБА 02.08.2012 11:07:33.783 NULL НУЛЕВОЙ - person Todd Li   schedule 09.08.2012
inst_id cons_code eff_date_time константа entry_user entry_date update_user update_date
1 PU 1901-01-01 17:00:00.000 833,2 dba 2012-08-02 11:28:27.287 NULL NULL
1 PU 1901-01-01 17:00:00.000 821,6 дБА 02.08.2012 11:28:27.287 NULL NULL
1 PU 1901-01-01 17:00:00.000 8 дБA 2012-08 -02 11:28:27.290 NULL NULL
1 PU 1901-01-01 17:00:00.000 2251 dba 2012-08-02 11:28:27.290 NULL NULL
2 PU 1901-01-01 17: 00:00.000 2251 дБА 02.08.2012 11:28:27.290 NULL NULL
2 PU 1901-01-01 17:00:00.000 22 дБА 02.08.2012 11:28:27.290 NULL NULL
2 PU 1901-01-01 17:00:00.000 820,9 дБА 02-08-2012 11:28:27.290 NULL NULL
2 PU 1901-01-01 17:00:00.000 833,2 дБА 02-08-2012 11:28 :27.290 NULL NULL
3 PU 1901-01-01 17:00:00.000 833,2 дБА 2012-08-02 11:28:27.290 NULL NULL
3 PU 1901-01-01 17:00:00.000 821,5 дБА 2012-08-02 11:28:27.290 NULL NULL
3 PU 1901-01- 01 17:00:00.000 8 dba 02-08-2012 11:28:27.290 NULL NULL
3 PU 1901-01-01 17:00:00.000 2095 dba 02-08-2012 11:28:27.293 NULL NULL< br> 4 PU 1901-01-01 17:00:00.000 2095 дБА 02.08.2012 11:28:27.293 NULL NULL
4 PU 1901-01-01 17:00:00.000 22 дБА 02-08-2012 11:28:27.293 NULL NULL
4 PU 1901-01-01 17:00:00.000 820,5 дБА 02.08.2012 11:28:27.293 NULL NULL
4 PU 1901-01-01 17:00: 00.000 833,2 дБА 02-08-2012 11:28:27.293 NULL NULL
A PU 1901-01-01 17:00:00.000 833,2 дБA 02-08-2012 11:28:27.293 NULL NULL
A PU 1901 -01-01 17:00:00.000 816,8 дБА 02-08-2012 11:28:27.293 NULL NULL
A PU 1901-01-01 17:00:00.000 120,5 дБА 02-08-2012 11:28:27.297 НУЛЕВОЙ NULL
A PU 1901-01-01 17:00:00.000 2255 дБА 02.08.2012 11:28:27.297 NULL NULL
A-1 AS 1972-07-01 00:00:00.000 1492 дБА 2012 -08-02 11:28:27.297 NULL NULL
A-1 AS 1972-07-01 00:00:00.000 986.48 dba 2012-08-02 11:28:27.297 NULL NULL
A-1 AS 1972 -07-01 00:00:00.000 0 дБА 02-08-2012 11:28:27.297 NULL NULL
A-10 AS 1972-07-01 00:00:00.000 0 дБА 02-08-2012 11:28 :27. 297 NULL NULL
A-10 AS 1972-07-01 00:00:00.000 986,48 дБА 02-08-2012 11:28:27.300 NULL NULL
A-10 AS 1972-07-01 00:00: 00.000 1857 дБА 02-08-2012 11:28:27.300 NULL NULL
A-11 AS 1972-07-01 00:00:00.000 1896 дБА 02-08-2012 11:28:27.300 NULL NULL
A -11 AS 1972-07-01 00:00:00.000 986,5 дБА 02.08.2012 11:28:27.300 NULL NULL
A-11 AS 1972-07-01 00:00:00.000 0 дБА 2012-08- 02 11:28:27.300 NULL NULL
A-12 AS 1972-07-01 00:00:00.000 0 dba 2012-08-02 11:28:27.300 NULL NULL
A-12 AS 1972-07- 01 00:00:00.000 986,5 дБА 02.08.2012 11:28:27.300 NULL NULL
A-12 AS 1972-07-01 00:00:00.000 1936 дБА 02.08.2012 11:28:27.300 NULL NULL
A-13 AS 1972-07-01 00:00:00.000 1976 dba 2012-08-02 11:28:27.300 NULL NULL
A-13 AS 1972-07-01 00:00:00.000 986.46 dba 2012-08-02 11:28:27.300 NULL NULL
A-13 A S 1972-07-01 00:00:00.000 0 dba 2012-08-02 11:28:27.303 NULL NULL
A-14 AS 1972-07-01 00:00:00.000 0 dba 2012-08-02 11 :28:27.303 NULL NULL
A-14 AS 1972-07-01 00:00:00.000 986,48 дБА 2012-08-02 11:28:27.303 NULL NULL
A-14 AS 1972-07-01 00 :00:00.000 2016 dba 02-08-2012 11:28:27.303 NULL NULL
A-15 AS 1972-07-01 00:00:00.000 0 dba 02-08-2012 11:28:27.303 NULL NULL - person Beth   schedule 21.08.2012