spEnsureFolderID

create procedure dbo.spEnsureFolderID(
@Type int,
@Name nvarchar(255),
@ParentFolderID int,
@ClientSitesID int
)
    as
    BEGIN

        DECLARE @RecordID  int
        declare @guid uniqueidentifier
        declare @owner int

        SET @RecordID = (SELECT TOP 1 [FolderID] 
            FROM [dbo].[SiteFolders] 
            WHERE [type] = @Type 
                AND [FolderName]=@Name
                and [deleted] = 0
                and (
                    coalesce(ParentFolderID,0) = coalesce(@ParentFolderID,0)
                )
            )

        if (IsNull(@RecordID,0) = 0)
        begin

           set @RecordID = -1
           set @owner = [dbo].fnGetSupervisorID()
           exec spAddUpdate_SiteFolders @RecordID output,@owner , 1, @Name, @ParentFolderID, 0, @type, @guid output

        end

        select @RecordID 
    END