USP_DATALIST_SPONSORSHIPOPPORTUNITYGROUP

create procedure dbo.USP_DATALIST_SPONSORSHIPOPPORTUNITYGROUP
as
    set nocount on;

    select 
        ID,
        NAME,
        SPONSORSHIPOPPORTUNITYTYPE,
        dbo.UFN_SPONSORSHIPOPPORTUNITIES_FOR_GROUP(ID) OPPORTUNITIES,
        case when ISINACTIVE = 1 then 'Inactive' else 'Active' end STATUS
    from dbo.SPONSORSHIPOPPORTUNITYGROUP
    order by NAME