fnSiteFolderNameAlreadyUsed

                CREATE FUNCTION [dbo].[fnSiteFolderNameAlreadyUsed]
                (
                    @FolderName nvarchar(255),
                    @ParentFolderID int,
                    @Type int,
                    @ClientSitesID int                
                )
                returns bit

                AS

                BEGIN
                    return(
                    SELECT CASE COUNT(FolderID) when 0 then 0 else 1 END
                    FROM dbo.SiteFolders 
                    WHERE FolderName = @FolderName
                    AND
                    coalesce(ParentFolderID, 0) = @ParentFolderID
                    AND
                    Type = @Type
                    AND
                    Deleted = 0
                    AND
                    ClientSitesID = @ClientSitesID
                    )
                END