USP_DATALIST_VOLUNTEERAVAILABILITY

This datalist returns all availabilities for a volunteer.

Parameters

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

Definition

Copy



            create procedure dbo.USP_DATALIST_VOLUNTEERAVAILABILITY (@VOLUNTEERID uniqueidentifier)
            as
                set nocount on;

                select     ID, 
                        STARTDATE,
                        ENDDATE,
                        DAYOFWEEK,
                        STARTTIME, 
                        ENDTIME
                from dbo.VOLUNTEERAVAILABILITY
                where VOLUNTEERID = @VOLUNTEERID
                order by STARTDATE, ENDDATE;

                return 0;