spContentTypes

CREATE PROCEDURE spContentTypes( 
    @ClientsID int, 
    @hidden bit ) 
AS 
    SELECT ContentTypes.* FROM ContentTypes JOIN ClientContentTypes ON ContentTypes.ID=ContentTypesID WHERE ClientsID=@ClientsID AND Hidden = @hidden ORDER BY ContentTypes.Name