fnValidateEmailKey

       CREATE function dbo.fnValidateEmailKey(@key nvarchar(25), @SiteContentID int)
    returns bit
    as
    BEGIN
    DECLARE @VALID as bit
    SET @VALID = 0

    IF EXISTS (SELECT ct.ID FROM dbo.ContentTypes ct inner join SiteContent sc
    on ct.ID = sc.ContentTypesID AND ct.MailKey = @key AND sc.ID = @SiteContentID)
    SET @VALID = 1

    RETURN @VALID
    END