UFN_TRACKITEM_GETSTAFFRESOURCES

        CREATE function dbo.UFN_TRACKITEM_GETSTAFFRESOURCES
        (
            @TRACKITEMID uniqueidentifier
        )
        returns table
        as return
            select TRACKITEMSTAFFRESOURCE.ID AS ID,
                    TRACKITEMSTAFFRESOURCE.VOLUNTEERTYPEID,
                    TRACKITEMSTAFFRESOURCE.JOBID,
                    TRACKITEMSTAFFRESOURCE.QUANTITYNEEDED,
                    TRACKITEMSTAFFRESOURCE.FILLEDBYCODE,
                    coalesce(JOB.NAME, TRACKITEMSTAFFRESOURCE.JOBNAME) as JOBNAME,
                    coalesce(JOB.DESCRIPTION, TRACKITEMSTAFFRESOURCE.JOBDESCRIPTION) as JOBDESCRIPTION,
                    VOLUNTEERTYPE.CAPACITYPERRESOURCE
            from dbo.TRACKITEMSTAFFRESOURCE
                left outer join dbo.JOB
                    on TRACKITEMSTAFFRESOURCE.JOBID = JOB.ID
                inner join dbo.VOLUNTEERTYPE
                    on VOLUNTEERTYPE.ID = TRACKITEMSTAFFRESOURCE.VOLUNTEERTYPEID
            where TRACKITEMSTAFFRESOURCE.TRACKITEMID = @TRACKITEMID