Begin Tran

Declare @hotelcd char(10)='HT17005161'

Select hotelcd, hotelnm from HEM037 where hotelcd=@hotelcd
Delete from HEM700 where hotelcd=@hotelcd

Insert into HEM700(hotelcd, stsdpbobd, stsdpspecialrt, stsdpwelcome, stsdpaccomm, stsdproom, stsdpadult, stsdpchild, stsdppromo, stsdpcurr, stsdpguestlist, stsmdguestlist, stsdpflightdet, stsdpnewsletter, stsdpspecialrq, stsdplang, stsmarketline, stsdpmap, stsdynamicmap, welcomemsg, packlistnumadult, specialrqlink, updater, lastupdate, stsdisproomtypecomp, stsdispratecomp, stsdisppackcomp)
Values (@hotelcd, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', (select hdetaildesc from HEM037 where hotelcd=@hotelcd), 1, NULL, 'AU00000001', getdate(), 'Y', 'Y', 'Y')

---Setup features
Update HEM060 set stsmobile='Y', stspromoavleu = 'Y', stspromoinclspcm = 'Y' where hotelcd=@hotelcd

---disable guestlist
Update HEM495 set stsDpGList='Y' where hotelcd=@hotelcd

---setup redirection
Update HEM037 set stsdirect='Y' where hotelcd=@hotelcd


Rollback