USP_SIMPLEDATALIST_PLANNEDGIFTLETTERCODEQUERYVIEW

                create procedure dbo.USP_SIMPLEDATALIST_PLANNEDGIFTLETTERCODEQUERYVIEW
                as
                    set nocount on;

                    select 
                        QUERYVIEWCATALOG.ID as VALUE,
                        QUERYVIEWCATALOG.DISPLAYNAME as LABEL
                    from
                        dbo.QUERYVIEWCATALOG 
                    --inner join

                    --    dbo.RECORDTYPE on QUERYVIEWCATALOG.RECORDTYPEID = RECORDTYPE.ID

                    where
                        QUERYVIEWSPEC.value
                        (
                            'declare namespace bbafx="bb_appfx_queryview";
                            declare namespace c="bb_appfx_commontypes";
                            (bbafx:QueryViewSpec/c:MetaTags/@AcknowledgementLetters)[1]','char(1)'
                        )='1'
                        --and upper(RECORDTYPE.NAME) = 'PLANNED GIFT';