USP_SIMPLEDATALIST_DISCOUNTADDRESSSELECTIONLIST

      CREATE procedure dbo.USP_SIMPLEDATALIST_DISCOUNTADDRESSSELECTIONLIST 
      as

        declare @SELECTIONS table (
          VALUE uniqueidentifier,
          LABEL nvarchar(200)
        )
        insert into @SELECTIONS 
            select IDSETREGISTER.ID as [VALUE],
                    IDSETREGISTER.NAME as [LABEL]
            from dbo.IDSETREGISTER
            inner join dbo.IDSETREGISTERSMARTQUERYINSTANCE on IDSETREGISTER.ID = IDSETREGISTERSMARTQUERYINSTANCE.IDSETREGISTERID
            inner join dbo.SMARTQUERYINSTANCE on SMARTQUERYINSTANCE.ID = IDSETREGISTERSMARTQUERYINSTANCE.SMARTQUERYINSTANCEID
              inner join dbo.SMARTQUERYCATALOG on SMARTQUERYINSTANCE.SMARTQUERYCATALOGID = SMARTQUERYCATALOG.ID
              left join dbo.RECORDTYPE on SMARTQUERYCATALOG.RECORDTYPEID = RECORDTYPE.ID
            where RECORDTYPE.NAME = 'Constituent' and SMARTQUERYCATALOG.NAME = 'Constituents by Address'
          order by [LABEL];

        select VALUE, LABEL from @SELECTIONS

        union all

                select cast('00000000-0000-0000-0000-000000000001' as uniqueidentifier) as [VALUE], 
                       cast('<Add new smart query>' as nvarchar(50)) as [LABEL];