Use HEMaster

BEGIN TRAN

delete from HEM792 where hotelcd = 'HT21005526'

insert into HEM790 (bobdcd, bobdnm, bobddesc,bobdcatcd,updater, lastupdate) values ('BBD1800250', 'Guarantee Late Check out at 3pm (Maximum)', NULL, 'BDC0005', 'AU00000001', getdate())
insert into HEM790 (bobdcd, bobdnm, bobddesc,bobdcatcd,updater, lastupdate) values ('BBD1800251', 'Free access to Gym', NULL, 'BDC0008', 'AU00000001', getdate())
insert into HEM790 (bobdcd, bobdnm, bobddesc,bobdcatcd,updater, lastupdate) values ('BBD1800252', 'Free 2 bottle water', NULL, 'BDC0006', 'AU00000001', getdate())

insert into HEM791 (bobdcd, assettype, url, dispnumb,updater, lastupdate) values ('BBD1800250', 'image', 'late-check-out.png', 275, 'AU00000001', getdate())
insert into HEM791 (bobdcd, assettype, url, dispnumb,updater, lastupdate) values ('BBD1800251', 'image', 'fitness-center.png', 52, 'AU00000001', getdate())
insert into HEM791 (bobdcd, assettype, url, dispnumb,updater, lastupdate) values ('BBD1800252', 'image', 'mineral-water-free.png', 277, 'AU00000001', getdate())

insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800076', 1, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800045', 2, getdate(), 'AU00000001') 
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800022', 3, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800250', 4, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800028', 5, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800050', 6, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800251', 7, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT21005526', 'BBD1800252', 8, getdate(), 'AU00000001')


ROLLBACK