begin tran

insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800005', 1, getdate(), 'AU00000001')		
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800028', 2, getdate(), 'AU00000001')		
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800230', 3, getdate(), 'AU00000001')		
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800079', 4, getdate(), 'AU00000001')		
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800068', 5, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800050', 6, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT24005734', 'BBD1800024', 7, getdate(), 'AU00000001')	


rollback