BEGIN TRAN

select * from hem790 where bobdcd=('BBD1800058','BBD1800239')
update hem790 set bobdnm='Free bus shuttle (based on availability)', lastupdate=getdate() where bobdcd='BBD1800058'
update hem790 set bobdnm='Free shuttle bus to Area Mall Batam (based on availability)', lastupdate=getdate() where bobdcd='BBD1800239'
select * from hem790 where bobdcd=('BBD1800058','BBD1800239')

delete from HEM792 where dispnumb in ('1','1','2','3','4','5','5','6','8') and hotelcd = 'HT23005594'

insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800005', 1, getdate(), 'AU00000001')		
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800239', 2, getdate(), 'AU00000001')		
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800019', 3, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800039', 4, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800030', 5, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800009', 6, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800028', 7, getdate(), 'AU00000001')	
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800068', 8, getdate(), 'AU00000001')
insert into HEM792 (hotelcd, bobdcd, dispnumb, lastupdate, updater) values ('HT23005594', 'BBD1800065', 9, getdate(), 'AU00000001')


ROLLBACK
--commit