USP_DATALIST_TRACKSTAFFRESOURCE

Gives the user a list of all the track staff resources used on an track.

Parameters

Parameter	Parameter Type	Mode	Description
@TRACKID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_TRACKSTAFFRESOURCE(@TRACKID uniqueidentifier)
                as
                    set nocount on;

                    select TRACKSTAFFRESOURCE.ID,
                           VOLUNTEERTYPE.ID,
                           VOLUNTEERTYPE.NAME,
                           case when VOLUNTEERTYPE.CAPACITYPERRESOURCE = 0 then TRACKSTAFFRESOURCE.QUANTITYNEEDED else null end as QUANTITYNEEDED,
                           case when VOLUNTEERTYPE.CAPACITYPERRESOURCE > 0 then VOLUNTEERTYPE.CAPACITYPERRESOURCE else null end as CAPACITYPERRESOURCE,
                           TRACKSTAFFRESOURCE.FILLEDBYCODE,
                           coalesce(JOB.NAME, TRACKSTAFFRESOURCE.JOBNAME) as JOBNAME,
                           coalesce(JOB.DESCRIPTION, TRACKSTAFFRESOURCE.JOBDESCRIPTION) as JOBDESCRIPTION,
                           TRACKSTAFFRESOURCE.FILLEDBY
                    from dbo.TRACKSTAFFRESOURCE
                        inner join dbo.VOLUNTEERTYPE
                            on TRACKSTAFFRESOURCE.VOLUNTEERTYPEID = VOLUNTEERTYPE.ID
                        left outer join dbo.JOB
                            on TRACKSTAFFRESOURCE.JOBID = JOB.ID
                    where TRACKSTAFFRESOURCE.TRACKID = @TRACKID