USP_CLONESITE_EVENTCALENDARHIGHLIGHT

CREATE procedure dbo.USP_CLONESITE_EVENTCALENDARHIGHLIGHT
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


INSERT INTO EventCalendarHighlight
(
        ShowUpcoming,
        ShowRecent,
        UpcomingDays,
        UpcomingTitle,
        RecentTitle,
        MoreEventURL,
        SiteContentID,
        CreateDate,
        ShowPrint,
        Categories
)
SELECT  ECH.ShowUpcoming,
        ECH.ShowRecent,
        ECH.UpcomingDays,
        ECH.UpcomingTitle,
        ECH.RecentTitle,
        ECH.MoreEventURL,
        SC.ID,
        getdate(),
        ECH.ShowPrint,
        ECH.Categories
FROM EventCalendarHighlight ECH
INNER JOIN SiteContent SC on SC.CopySourceID = ECH.SiteContentID and SC.CopyBatchGUID = @CopyBatchGUID

INSERT INTO EventCalendarHighlightDetail
(
        EventCalendarHighlightID,
        SrcCalendarID,
        IconID,
        DisplayColor
)
SELECT ECH2.ID,
       EC2.ID,
       ISNULL(SI.ID,ECHD.IconID),
       ECHD.DisplayColor
FROM EventCalendarHighlightDetail ECHD
INNER JOIN EventCalendarHighlight ECH on ECH.ID = ECHD.EventCalendarHighlightID
INNER JOIN SiteContent SC on SC.CopySourceID = ECH.SiteContentID and SC.CopyBatchGUID = @CopyBatchGUID
INNER JOIN EventCalendarHighlight ECH2 on ECH2.SiteContentID = SC.ID
INNER JOIN EventCalendar EC on EC.ID = ECHD.SrcCalendarID
INNER JOIN SiteContent SC2 on SC2.CopySourceID = EC.SiteContentID and SC.CopyBatchGUID = @CopyBatchGUID
INNER JOIN EventCalendar EC2 on EC2.SiteContentID = SC2.ID
LEFT JOIN SiteImages SI on SI.CopySourceID = ECHD.IconID and SI.CopyBatchGUID = @CopyBatchGUID

--Update XML Data 

declare @Data xml
set @Data = 
(
    select P.SiteContentID, ECH.ID as Value
    from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,98, 'EventCalendarHighlightID') P
    inner join dbo.EventCalendarHighlight ECH on ECH.SiteContentID = P.SiteContentID
    FOR XML RAW, ELEMENTS
)    
exec USP_UPDATEXMLPROPERTYFORSITECOPY 'EventCalendarHighlightID', @Data