SET IDENTITY_INSERT table1 ON
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 1 ,'11111', 1000 ,'Jan  1 2002 12:00AM','Apr 30 2002 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 10 ,'44444', 4001 ,'Jul  1 2002 12:00AM','Dec 31 2099 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 2 ,'11111', 1000 ,'May  1 2002 12:00AM','Jul 31 2002 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 3 ,'11111', 1001 ,'Aug  1 2002 12:00AM','Dec 31 2099 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 4 ,'22222', 2000 ,'May  1 2002 12:00AM','May 30 2002 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 5 ,'22222', 2000 ,'Jun  1 2002 12:00AM','Jul 31 2002 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 6 ,'22222', 2000 ,'Aug  1 2002 12:00AM','Dec 31 2099 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 7 ,'33333', 3000 ,'May  1 2002 12:00AM','Jul 15 2002 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 8 ,'33333', 3000 ,'Jul 15 2002 12:00AM','Dec 31 2099 12:00AM')
insert into table1(id,num_tab,struct_code,date_beg,date_end) values( 9 ,'44444', 4000 ,'Feb  1 2002 12:00AM','Jun 30 2002 12:00AM')
SET IDENTITY_INSERT table1 OFF
GO
drop table table2
SET IDENTITY_INSERT table2 ON
create table table2 (id int identity ( 1 , 1 ),num_tab varchar ( 10 ),struct_code int,date_beg datetime,date_end datetime,prizn int)
insert into table2(id,num_tab,struct_code,date_beg,date_end,prizn) values( 1 ,'11111', 1000 ,'May  1 2002 12:00AM','Jul 31 2002 12:00AM', 31 )
insert into table2(id,num_tab,struct_code,date_beg,date_end,prizn) values( 2 ,'11111', 1001 ,'Aug  1 2002 12:00AM','Dec 31 2002 12:00AM', 32 )
insert into table2(id,num_tab,struct_code,date_beg,date_end,prizn) values( 3 ,'22222', 2000 ,'Mar  1 2002 12:00AM','Jul 31 2002 12:00AM', 41 )
insert into table2(id,num_tab,struct_code,date_beg,date_end,prizn) values( 4 ,'22222', 2000 ,'Aug  1 2002 12:00AM','Dec 31 2099 12:00AM', 42 )
SET IDENTITY_INSERT table2 OFF
GO