begin tran

select * from hem792 where hotelcd='HT12004912'
delete from hem792 where hotelcd='HT12004912'

insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800071', 1, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800111', 2, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800105', 3, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800106', 4, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800108', 5, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800109', 6, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800110', 7, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT12004912', 'BBD1800005', 8, getdate(), 'AU00000001')


rollback