UFN_ITINERARYITEMSTAFFRESOURCE_GETASSIGNEDSTAFF

            CREATE function dbo.UFN_ITINERARYITEMSTAFFRESOURCE_GETASSIGNEDSTAFF
            (
                @ITINERARYITEMID uniqueidentifier
            )
            returns table
            as return 
                select VOLUNTEERTYPE.NAME as VOLUNTEERTYPENAME,
                        ITINERARYITEMSTAFFRESOURCE.FILLEDBYCODE,
                        ITINERARYITEMSTAFFRESOURCE.QUANTITYNEEDED,
                        ITINERARYITEMSTAFFRESOURCE.JOBOCCURRENCEID,
                        VOLUNTEERASSIGNMENT.ID as VOLUNTEERASSIGNMENTID,
                        VOLUNTEERASSIGNMENT.VOLUNTEERID,
                        VOLUNTEERASSIGNMENT.DATE,
                        ITINERARYITEMSTAFFRESOURCE.ID as ITINERARYITEMSTAFFRESOURCEID,
                        ITINERARYITEMSTAFFRESOURCEASSIGNMENT.ID as ITINERARYITEMSTAFFRESOURCEASSIGNMENTID,
                        ITINERARYITEMSTAFFRESOURCEASSIGNMENT.CONSTITUENTID,
                        (select top 1 NUMBER
                            from dbo.UFN_CONSTITUENT_GETPHONES(coalesce(VOLUNTEERASSIGNMENT.VOLUNTEERID, ITINERARYITEMSTAFFRESOURCEASSIGNMENT.CONSTITUENTID))
                            where (ISPRIMARY = 1)) as PRIMARYPHONE
                from dbo.ITINERARYITEMSTAFFRESOURCE
                    left outer join dbo.VOLUNTEERASSIGNMENT
                        on ITINERARYITEMSTAFFRESOURCE.JOBOCCURRENCEID = VOLUNTEERASSIGNMENT.JOBOCCURRENCEID and 
                            ITINERARYITEMSTAFFRESOURCE.FILLEDBYCODE = 0
                    left outer join dbo.ITINERARYITEMSTAFFRESOURCEASSIGNMENT
                        on ITINERARYITEMSTAFFRESOURCEASSIGNMENT.ITINERARYITEMSTAFFRESOURCEID = ITINERARYITEMSTAFFRESOURCE.ID and 
                            ITINERARYITEMSTAFFRESOURCE.FILLEDBYCODE != 0
                    inner join dbo.VOLUNTEERTYPE
                        on ITINERARYITEMSTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                where ITINERARYITEMSTAFFRESOURCE.ITINERARYITEMID = @ITINERARYITEMID