USP_DATALIST_RESEARCHGROUPMEMBERWEALTH

CREATE procedure dbo.USP_DATALIST_RESEARCHGROUPMEMBERWEALTH
(
    @RESEARCHGROUPID uniqueidentifier
)
as
    set nocount on;

    select
        WEALTH.ID,
        case 
            when WEALTH.REALESTATENUMBER = 0 then null 
            else WEALTH.REALESTATEASSETS 
        end as REALESTATEASSETS,
        case 
            when WEALTH.SECURITIESNUMBER = 0 then null 
            else WEALTH.SECURITIESASSETS 
        end as SECURITIESASSETS,
        case 
            when WEALTH.BUSINESSOWNERSHIPNUMBER = 0 then null 
            else WEALTH.BUSINESSOWNERSHIPASSETS 
        end as BUSINESSOWNERSHIPASSETS,
        case 
            when WEALTH.AFFLUENCEINDICATORNUMBER = 0 then null 
            else WEALTH.AFFLUENCEINDICATORASSETS 
        end as AFFLUENCEINDICATORASSETS,
        case 
            when WEALTH.OTHERASSETSNUMBER = 0 then null 
            else WEALTH.OTHERASSETS end as OTHERASSETS,
        TOTALASSETS,
        case 
            when WEALTH.INCOMECOMPENSATIONNUMBER = 0 then null 
            else WEALTH.INCOMECOMPENSATIONASSETS 
        end as INCOMECOMPENSATIONASSETS,
        case 
            when WEALTH.REALESTATENUMBERCONFIRMED = 0 then null 
            else WEALTH.REALESTATEASSETSCONFIRMED 
        end as REALESTATEASSETSCONFIRMED,
        case 
            when WEALTH.SECURITIESNUMBERCONFIRMED = 0 then null 
            else WEALTH.SECURITIESASSETSCONFIRMED 
        end as SECURITIESASSETSCONFIRMED,
        case 
            when WEALTH.BUSINESSOWNERSHIPNUMBERCONFIRMED = 0 then null 
            else WEALTH.BUSINESSOWNERSHIPASSETSCONFIRMED 
        end as BUSINESSOWNERSHIPASSETSCONFIRMED,
        case 
            when WEALTH.AFFLUENCEINDICATORNUMBERCONFIRMED = 0 then null 
            else WEALTH.AFFLUENCEINDICATORASSETSCONFIRMED 
        end as AFFLUENCEINDICATORASSETSCONFIRMED,
        case 
            when WEALTH.OTHERASSETSNUMBERCONFIRMED = 0 then null 
            else WEALTH.OTHERASSETSCONFIRMED 
        end as OTHERASSETSCONFIRMED,
        TOTALASSETSCONFIRMED,
        case 
            when WEALTH.INCOMECOMPENSATIONNUMBERCONFIRMED = 0 then null 
            else WEALTH.INCOMECOMPENSATIONASSETSCONFIRMED 
        end as INCOMECOMPENSATIONASSETSCONFIRMED,
        WEALTH.BIOGRAPHICALNUMBER,
        WEALTH.POLITICALDONATIONNUMBER,
        WEALTH.PRIVATEFOUNDATIONNUMBER,
        WEALTH.PHILANTHROPICGIFTNUMBER,
        WEALTH.INCOMECOMPENSATIONNUMBER,
        WEALTH.AFFLUENCEINDICATORNUMBER,
        WEALTH.NONPROFITAFFILIATIONNUMBER,
        WEALTH.OTHERASSETSNUMBER,
        WEALTH.BUSINESSOWNERSHIPNUMBER,
        WEALTH.REALESTATENUMBER,
        WEALTH.SECURITIESNUMBER,
        WEALTH.BIOGRAPHICALNUMBERCONFIRMED,
        WEALTH.POLITICALDONATIONNUMBERCONFIRMED,
        WEALTH.PRIVATEFOUNDATIONNUMBERCONFIRMED,
        WEALTH.PHILANTHROPICGIFTNUMBERCONFIRMED,
        WEALTH.INCOMECOMPENSATIONNUMBERCONFIRMED,
        WEALTH.AFFLUENCEINDICATORNUMBERCONFIRMED,
        WEALTH.NONPROFITAFFILIATIONNUMBERCONFIRMED,
        WEALTH.OTHERASSETSNUMBERCONFIRMED,
        WEALTH.BUSINESSOWNERSHIPNUMBERCONFIRMED,
        WEALTH.REALESTATENUMBERCONFIRMED,
        WEALTH.SECURITIESNUMBERCONFIRMED
    from 
        dbo.RESEARCHGROUPMEMBER
        left join dbo.WEALTH on WEALTH.ID = RESEARCHGROUPMEMBER.CONSTITUENTID
    where RESEARCHGROUPMEMBER.RESEARCHGROUPID = @RESEARCHGROUPID