USP_SIMPLEDATALIST_MEMBERSHIPCARDFORMAT

            CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPCARDFORMAT as
            select 
                ID as VALUE, 
                NAME as LABEL
            from dbo.REPORTCATALOG
            where convert(nvarchar(255),REPORTSPECXML.query('/*:ReportSpec/*:Folder')) like '%System Reports\Membership\Card Formats%' 
            order by NAME