create table xintegration_mapping4 (fromvalue1 varchar(50), tovalue1 varchar(50)); insert into xintegration_mapping4 values ('1314', '1084'); insert into xintegration_mapping4 values ('1330', '1084'); insert into xintegration_mapping4 values ('1401', '1084'); insert into xintegration_mapping4 values ('R580', '1084'); create table xepic_episode3 (cpr varchar(50), rowno varchar(50), hospitalcode varchar(50)); insert into xepic_episode3 values ('1234567890', '1', '1330'); insert into xepic_episode3 values ('1234567890', '2', '1330'); insert into xepic_episode3 values ('1234567890', '3', '1330'); insert into xepic_episode3 values ('1234567890', '4', '1330'); insert into xepic_episode3 values ('1234567890', '5', '1330'); insert into xepic_episode3 values ('1234567890', '6', '1330'); insert into xepic_episode3 values ('1234567890', '7', '1330'); insert into xepic_episode3 values ('1234567890', '8', '1330'); insert into xepic_episode3 values ('1234567890', '9', '1330'); insert into xepic_episode3 values ('1234567890', '10', '1330'); insert into xepic_episode3 values ('1234567890', '11', '1330'); insert into xepic_episode3 values ('1234567890', '12', '1330'); insert into xepic_episode3 values ('1234567890', '13', '1330'); insert into xepic_episode3 values ('1234567890', '14', '1330'); insert into xepic_episode3 values ('1234567890', '15', '1330'); insert into xepic_episode3 values ('1234567890', '16', '1330'); insert into xepic_episode3 values ('1234567890', '17', '1330'); insert into xepic_episode3 values ('1234567890', '18', '1330'); insert into xepic_episode3 values ('1234567890', '19', '1330'); insert into xepic_episode3 values ('1234567890', '20', '1330'); insert into xepic_episode3 values ('1234567890', '21', '1330'); insert into xepic_episode3 values ('1234567890', '22', '1330'); insert into xepic_episode3 values ('1234567890', '23', '1330'); insert into xepic_episode3 values ('1234567890', '24', '1330');