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