USP_VOLUNTEER_JOBOCCURRENCE_GETDAYS

Returns all date assignments for a given volunteers and occurrence.

Parameters

Parameter	Parameter Type	Mode
@VOLUNTEERID	uniqueidentifier	IN
@JOBOCCURRENCEID	uniqueidentifier	IN
@STARTDATE	date	IN
@ENDDATE	date	IN

Definition

Copy



CREATE procedure dbo.USP_VOLUNTEER_JOBOCCURRENCE_GETDAYS 
(
    @VOLUNTEERID uniqueidentifier, 
    @JOBOCCURRENCEID uniqueidentifier, 
    @STARTDATE date,
    @ENDDATE date        
)
as
    set nocount on;

    select 
        VOLUNTEERASSIGNMENT.ID,
        SCHEDULE.ASSIGNMENTDATE,
        SCHEDULE.OPENINGS,
        VOLUNTEERASSIGNMENT.VOLUNTEERID
    from 
        dbo.[UFN_JOBOCCURRENCE_SCHEDULE](@STARTDATE,@ENDDATE,@JOBOCCURRENCEID,null) SCHEDULE
    left join dbo.VOLUNTEERASSIGNMENT
        on VOLUNTEERASSIGNMENT.DATE = SCHEDULE.ASSIGNMENTDATE
            and VOLUNTEERASSIGNMENT.JOBOCCURRENCEID = @JOBOCCURRENCEID
            and VOLUNTEERASSIGNMENT.VOLUNTEERID = @VOLUNTEERID
    order by
        SCHEDULE.ASSIGNMENTDATE desc;