USP_DATALIST_SPONSORSHIPOPPORTUNITYGROUPINFO

create procedure dbo.USP_DATALIST_SPONSORSHIPOPPORTUNITYGROUPINFO(
    @CONTEXTID uniqueidentifier
)
as
    set nocount on;

    select
        SG.ID,
        SG.NAME,
        SG.SPONSORSHIPOPPORTUNITYTYPECODE,
        case when SG.OVERRIDESPONSORSPEROPPORTUNITY is null then SG.OFFERSOLESPONSORSHIP else 0 end OFFERSOLESPONSORSHIP,
        SG.SPONSORSPEROPPORTUNITY,
        SG.SPONSORSHIPLOCATIONID,
        dbo.UFN_SPONSORSHIPLOCATION_GETFULLNAME(SG.SPONSORSHIPLOCATIONID) LOCATION,
        SG.GENDERCODE,
        SG.ISHIVPOSITIVECODE,
        SG.ISORPHANEDCODE,
        SG.HASCONDITIONCODE,
        SG.SPONSORSHIPOPPORTUNITYAGERANGEID,
        SG.SPROPPPROJECTCATEGORYCODEID,
        SPC.DESCRIPTION,
        case when SG.OVERRIDESPONSORSPEROPPORTUNITY is null then 0 else 1 end HASOVERRIDES
    from dbo.SPONSORSHIPOPPORTUNITYGROUP SG
    left join SPONSORSHIPOPPORTUNITYAGERANGE SOAR on SOAR.ID= SG.SPONSORSHIPOPPORTUNITYAGERANGEID
    left join SPROPPPROJECTCATEGORYCODE SPC on SPC.ID = SG.SPROPPPROJECTCATEGORYCODEID
    where SG.ID = @CONTEXTID