USP_DATAFORMTEMPLATE_VIEW_JOBOCCURRENCEPROFILE_CALENDAR

The load procedure used by the view dataform template "Job Occurrence Profile Calendar View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@JOBOCCURRENCE	nvarchar(30)	INOUT	JOBOCCURRENCE
@DATES	nvarchar(40)	INOUT	DATES
@HOURS	nvarchar(30)	INOUT	HOURS

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_JOBOCCURRENCEPROFILE_CALENDAR
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @JOBOCCURRENCE nvarchar(30) = null output,
    @DATES nvarchar(40) = null output,
    @HOURS nvarchar(30) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    declare @STARTDATE date,
            @ENDDATE date;

    select
        @DATALOADED = 1,
        @JOBOCCURRENCE = JOBOCCURRENCE.DESCRIPTION,
        @STARTDATE = JOBOCCURRENCE.STARTDATE,
        @ENDDATE = JOBOCCURRENCE.ENDDATE,
        @HOURS = (case when JOBOCCURRENCE.STARTTIME is null then 'All day' else 
                    dbo.UFN_JOB_DISPLAYTIME(JOBOCCURRENCE.STARTTIME, JOBOCCURRENCE.ENDTIME) end)                                   
    from dbo.JOBOCCURRENCE
    inner join dbo.JOB
        on JOBOCCURRENCE.JOBID = JOB.ID
    where JOBOCCURRENCE.ID = @ID;

    set @DATES = 
        DATENAME(MONTH, @STARTDATE) + SUBSTRING(CONVERT(VARCHAR(30), @STARTDATE, 107), 4, 20) + ' - ' +
        DATENAME(MONTH, @ENDDATE) + SUBSTRING(CONVERT(VARCHAR(30), @ENDDATE, 107), 4, 20);

    return 0;