begin tran

DECLARE @hotelcd1 char(10) = 'HT16005121' --> Fill in to update

select @hotelcd1, hotelnm, stsrateavlmb, stspromoavleu from HEM037 join HEM060 on HEM037.hotelcd = HEM060.hotelcd where HEM037.hotelcd = @hotelcd1 

Update HEM060 set stsrateavlmb = 'Y', stspromoavleu = 'Y' where hotelcd=@hotelcd1


Insert into HEM375 (htlCCCode, hotelCd, stsJoin, joinDate, updater, lastupdate)
	Values ('HCC1600144', @hotelcd1, 'Y', getdate(), 'AU00000001', getdate())

rollback