spGetIncompatibleContentTypes

      CREATE PROCEDURE dbo.spGetIncompatibleContentTypes(@PageId int)
    AS

    --Returns content type ids that are not compatible with the current page

    DECLARE @IDS Table(Id int)
    INSERT INTO @IDS(Id) SELECT ContentTypesID FROM dbo.fnPageAndTemplatePartsList(@PageID)

    SELECT ICT.IncompatibleContentID FROM dbo.IncompatibleContentTypes ICT
    WHERE ICT.ContentTypeID IN (SELECT DISTINCT id FROM @IDS)