UFN_VOLUNTEER_AVAILABLEFORALLDATES

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@DAYSXML	xml	IN
@DAYCOUNT	int	IN
@VOLUNTEERID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN

Definition

Copy



create function dbo.UFN_VOLUNTEER_AVAILABLEFORALLDATES(@DAYSXML xml, @DAYCOUNT int, @VOLUNTEERID uniqueidentifier, @CURRENTDATE datetime)
returns table as return
    select 
        AVAILABILITY.AVAILABLEDATE, 
        AVAILABILITY.VOLUNTEERID, 
        AVAILABILITY.STARTTIME, 
        AVAILABILITY.ENDTIME
    from 
        dbo.[UFN_VOLUNTEER_AVAILABLESPECIFICDAYS_2](@DAYSXML, @VOLUNTEERID, @CURRENTDATE) AVAILABILITY
    where
        AVAILABILITY.VOLUNTEERID in (
            select VOLUNTEERID
            from dbo.[UFN_VOLUNTEER_AVAILABLESPECIFICDAYS_2](@DAYSXML, @VOLUNTEERID, @CURRENTDATE) AVAILABILITY
            group by VOLUNTEERID
            having count(*) >= @DAYCOUNT
        )