Begin Tran

Declare @hotelcd char(10)='HT18005297'

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, packlistnumadult, specialrqlink, updater, lastupdate, stsdisproomtypecomp, stsdispratecomp, stsdisppackcomp, accommndays , packlistndays, accommstshdrate, accommstshdbook, stshdrrlos, stsdprrcta, stsdprrcod)
Values (@hotelcd, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 1, NULL, 'AU00000001', getdate(), 'Y', 'Y', 'Y', 0, 30, NULL, NULL, NULL, NULL, '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