fnContentTypeAvailable

            CREATE  FUNCTION [dbo].[fnContentTypeAvailable]
                (    
                    @ClientsID int,
                    @ContentTypesID int
                )
                RETURNS bit
                AS
                BEGIN            

                    return (SELECT Count(*) As Available
                                    FROM 
                                    ContentTypes JOIN ClientContentTypes 
                                    ON ContentTypes.ID=ClientContentTypes.ContentTypesID 
                                    WHERE 
                                    ClientsID = @ClientsID AND 
                                    ContentTypes.ID = @ContentTypesID AND
                                    Static=0 AND Hidden=0);
                END