USP_SIMPLEDATALIST_SPONSORSHIPOPPORTUNITYRESERVATIONAGERANGE

Returns a list of all age range code id's for the reservations.

Definition

Copy


        CREATE procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPOPPORTUNITYRESERVATIONAGERANGE as
           select 
          ID as VALUE
          DISPLAYNAME as LABEL,
          MINAGE as DESCRIPTION
          from dbo.SPONSORSHIPOPPORTUNITYAGERANGE
         union
         select 
          '626658D1-E24B-4370-952D-1080B22C33AE' as VALUE,
          'Balanced' as LABEL, 
          999 as DESCRIPTION
          from dbo.SPONSORSHIPOPPORTUNITYAGERANGE
          order by DESCRIPTION