spGetSiteCopyForClientSites

    CREATE PROCEDURE dbo.spGetSiteCopyForClientSites
    (
    @ClientSitesID int = null,
    @CopyBatchGUID uniqueidentifier = null
    )
    AS

    if @ClientSitesID > 0
    begin
    SELECT ID, CreateDate, OwnerUserID, SourceClientSitesID, TargetClientSitesID, Status, ErrorLog, RollbackUserID, RollbackDate
    FROM SiteCopy WHERE TargetClientSitesID = @ClientSitesID ORDER BY Status ASC, CreateDate DESC
    end
    else
    begin
    SELECT ID, CreateDate, OwnerUserID, SourceClientSitesID, TargetClientSitesID, Status, ErrorLog, RollbackUserID, RollbackDate
    FROM SiteCopy WHERE ID = @CopyBatchGUID
    end