spCloneSite_ImageFolders

    CREATE PROCEDURE [dbo].[spCloneSite_ImageFolders]
    (
    @CopyBatchGUID uniqueidentifier
    )

    AS

    INSERT INTO SiteImageFolders
    (SiteImageID, SiteFolderID, CopySourceID, CopyBatchGUID)
    SELECT SiteImages.ID, SiteFolders.FolderID, SiteImageFolders.ID,  @CopyBatchGUID
    FROM SiteImageFolders
    INNER JOIN SiteImages ON SiteImages.CopySourceID = SiteImageFolders.SiteImageID AND SiteImages.CopyBatchGUID = @CopyBatchGUID
    INNER JOIN SiteFolders ON SiteFolders.CopySourceID = SiteImageFolders.SiteFolderID AND SiteFolders.CopyBatchGUID = @CopyBatchGUID