fnPageHasContentType

CREATE FUNCTION [dbo].[fnPageHasContentType]
(
    @SitePageID int,
    @ContentTypesID int
)
RETURNS bit
AS
BEGIN
    DECLARE @Match bit
    SET @Match = 1

    -- page has no content
    IF (@ContentTypesID = -2)
        IF EXISTS (
            SELECT TOP 1 PageContent.ID
              FROM dbo.PageContent
             INNER JOIN dbo.SiteContent ON PageContent.SiteContentID = SiteContent.ID
             WHERE PageContent.SitePagesID = @SitePageID and SiteContent.Deleted = 0)
            SET @Match = 0

    -- page has at least one content of any type
    IF (@ContentTypesID = -1)
        IF NOT EXISTS (
            SELECT TOP 1 PageContent.ID
              FROM dbo.PageContent
             INNER JOIN dbo.SiteContent ON PageContent.SiteContentID = SiteContent.ID
             WHERE PageContent.SitePagesID = @SitePageID and SiteContent.Deleted = 0)
            SET @Match = 0

    IF (@ContentTypesID > 0)
        IF NOT EXISTS (
            SELECT TOP 1 PageContent.ID
              FROM dbo.PageContent
             INNER JOIN dbo.SiteContent ON PageContent.SiteContentID = SiteContent.ID
             WHERE PageContent.SitePagesID = @SitePageID
               AND SiteContent.ContentTypesID = @ContentTypesID and SiteContent.Deleted = 0)
            SET @Match = 0

    RETURN @Match
END