USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILLCOPY_PRELOAD

The load procedure used by the edit dataform template "Course Student Skill Add Copy Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTSKILLID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@COURSEID	uniqueidentifier	INOUT
@STUDENTSKILLRATINGGROUPID	uniqueidentifier	INOUT	Rating
@NAME	nvarchar(400)	INOUT	Skill name
@STARTDATE	datetime	INOUT	Start using on
@ENDDATE	datetime	INOUT	Stop using after
@STUDENTSKILLMARKINGCOLUMNS	xml	INOUT	Marking Columns

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILLCOPY_PRELOAD
(
    @STUDENTSKILLID uniqueidentifier,
    @COURSEID uniqueidentifier = null output,
    @STUDENTSKILLRATINGGROUPID uniqueidentifier = null output,
    @NAME nvarchar(400) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @STUDENTSKILLMARKINGCOLUMNS xml = null output
)
as
    set nocount on;

    select 
        @NAME = STUDENTSKILL.NAME,
        @STUDENTSKILLRATINGGROUPID = STUDENTSKILL.STUDENTSKILLRATINGGROUPID,
        @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate()),
        @STUDENTSKILLMARKINGCOLUMNS = dbo.UFN_STUDENTSKILL_GETMARKINGCOLUMN_TOITEMLISTXML(@STUDENTSKILLID),
        @COURSEID = STUDENTSKILLCOURSE.COURSEID
    from dbo.STUDENTSKILL
        left join dbo.STUDENTSKILLCOURSE on STUDENTSKILLCOURSE.STUDENTSKILLID = STUDENTSKILL.ID
    where dbo.STUDENTSKILL.ID = @STUDENTSKILLID

    -- remove PK ID's, saving copy will generate new ones.

    if @STUDENTSKILLMARKINGCOLUMNS is not null
        set @STUDENTSKILLMARKINGCOLUMNS.modify('delete /STUDENTSKILLMARKINGCOLUMNS/ITEM/ID')

    return 0;