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;