USP_QUERYVIEWCATALOG_GETATTRIBUTEEXTENSIONQUERYVIEWS

Definition

Copy


        CREATE procedure dbo.USP_QUERYVIEWCATALOG_GETATTRIBUTEEXTENSIONQUERYVIEWS
        as
        begin
            select
                QUERYVIEWCATALOG.QUERYVIEWSPEC,
                QUERYVIEWEXTENSIONCATALOG.ID ATTRIBUTEEXTENSIONID
            from dbo.QUERYVIEWCATALOG
            left join dbo.QUERYVIEWEXTENSIONCATALOG
                on QUERYVIEWCATALOG.ID = QUERYVIEWEXTENSIONCATALOG.QUERYVIEWCATALOGID
                and QUERYVIEWEXTENSIONCATALOG.ISATTRIBUTEEXTENSION = 1
            where QUERYVIEWCATALOG.ALLOWATTRIBUTEEXTENSION = 1
        end