USP_CLONESITE_EVENTCALENDARGROUP

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


INSERT INTO EventCalendarView
(
        Name,
        CreateDate,
        SiteContentID,
        Categories
)
SELECT ECV.Name,
       getdate(),
       SC.ID,
       ECV.Categories
FROM EventCalendarView ECV
INNER JOIN SiteContent SC on SC.CopySourceID = ECV.SiteContentID and SC.CopyBatchGUID = @CopyBatchGUID

INSERT INTO EventCalendarViewDetail
(
        EventCalendarViewID,
        SubcalendarID,
        IconID,
        DisplayColor
)
SELECT ECV2.ID,
       EC2.ID,
       ISNULL(SI.ID,ECVD.IconID),
       ECVD.DisplayColor
FROM EventCalendarViewDetail ECVD
INNER JOIN EventCalendarView ECV on ECV.ID = ECVD.EventCalendarViewID
INNER JOIN SiteContent SC on SC.CopySourceID = ECV.SiteContentID and SC.CopyBatchGUID = @CopyBatchGUID
INNER JOIN EventCalendarView ECV2 on ECV2.SiteContentID = SC.ID
INNER JOIN EventCalendar EC on EC.ID = ECVD.SubcalendarID
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 = ECVD.IconID and SI.CopyBatchGUID = @CopyBatchGUID

--Update XML Data 

declare @Data xml
set @Data = 
(
    select P.SiteContentID, ECV.ID as Value
    from dbo.UFN_GETXMLPROPERTYFORSITECOPY(@CopyBatchGuid,96, 'EventCalendarViewID') P
    inner join dbo.EventCalendarView ECV on ECV.SiteContentID = P.SiteContentID
    FOR XML RAW, ELEMENTS
)    
exec USP_UPDATEXMLPROPERTYFORSITECOPY 'EventCalendarViewID', @Data