USP_DATALIST_VOLUNTEERAVAILABILITY2

Parameters

Parameter Parameter Type Mode Description
@VOLUNTEERID uniqueidentifier IN

Definition

Copy


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

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

                return 0;