USP_DATALIST_STAFF_RESOURCE

            CREATE procedure dbo.USP_DATALIST_STAFF_RESOURCE
            as
                set nocount on;

                select 
                    VOLUNTEERTYPE.[ID],
                    [NAME],
                    [QUANTITY],
                    [CAPACITYPERRESOURCE],
                    COALESCE([PRICINGSTRUCTURE], dbo.UFN_VOLUNTEERTYPEPRICING_PRICINGSTRUCTURECODE_GETDESCRIPTION(0)) as [PRICINGSTRUCTURE],
                    CASE WHEN [PRICE] <= 0 THEN null ELSE [PRICE] END as [PRICE],
                    [RETURNAMOUNT],
                    [DESCRIPTION]
                from 
                    dbo.[VOLUNTEERTYPE]
                        left join dbo.[VOLUNTEERTYPEPRICING] on [VOLUNTEERTYPE].ID = [VOLUNTEERTYPEPRICING].ID
                order by
                    VOLUNTEERTYPE.[NAME]