USP_DATALIST_JOBOCCURRENCESCHEDULE_NO_OPENINGS_CALENDAR
This datalist returns all dates without openings for an occurrence including assignments, used by the Job Occurrence Schedule Calendar.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @JOBOCCURRENCEID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
| @STARTDATE | datetime | IN | |
| @ENDDATE | datetime | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_JOBOCCURRENCESCHEDULE_NO_OPENINGS_CALENDAR (
@JOBOCCURRENCEID uniqueidentifier = null,
@STARTDATE datetime = null,
@ENDDATE datetime = null,
@CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;
exec dbo.USP_JOBOCCURRENCE_CALENDARITEMS @JOBOCCURRENCEID, @STARTDATE, @ENDDATE, @CURRENTAPPUSERID, 0