Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @FromSiteId INT = 3
- DECLARE @ToSiteId INT = 6
- UPDATE realestate_GlobalSettings SET
- ListItemHtmlTemplate = (SELECT ListItemHtmlTemplate FROM realestate_GlobalSettings WHERE SiteId = @FromSiteId) ,
- FeaturedListItemHtmlTemplate = (SELECT FeaturedListItemHtmlTemplate FROM realestate_GlobalSettings WHERE SiteId = @FromSiteId) ,
- ListingDetailsHtmlTemplate = (SELECT ListingDetailsHtmlTemplate FROM realestate_GlobalSettings WHERE SiteId = @FromSiteId) ,
- MapInfoHtmlTemplate = (SELECT MapInfoHtmlTemplate FROM realestate_GlobalSettings WHERE SiteId = @FromSiteId) ,
- PresentationModeListingTemplate = (SELECT PresentationModeListingTemplate FROM realestate_GlobalSettings WHERE SiteId = @FromSiteId)
- WHERE
- SiteId = @ToSiteId
Add Comment
Please, Sign In to add comment