USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILLCOPY

The save procedure used by the add 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	IN
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@STUDENTSKILLRATINGGROUPID	uniqueidentifier	IN	Rating
@NAME	nvarchar(400)	IN	Skill name
@STARTDATE	datetime	IN	Start using on
@ENDDATE	datetime	IN	Stop using after
@STUDENTSKILLMARKINGCOLUMNS	xml	IN	Marking Columns

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILLCOPY
(
    @STUDENTSKILLID uniqueidentifier,
    @COURSEID uniqueidentifier = null,
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @STUDENTSKILLRATINGGROUPID uniqueidentifier = null,
    @NAME nvarchar(400) = '',
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @STUDENTSKILLMARKINGCOLUMNS xml = null
)
as

if @COURSEID is null
    select 
        @COURSEID = STUDENTSKILLCOURSE.COURSEID
    from dbo.STUDENTSKILLCOURSE     
    where dbo.STUDENTSKILLCOURSE.STUDENTSKILLID = @STUDENTSKILLID

exec dbo.USP_DATAFORMTEMPLATE_ADD_COURSESTUDENTSKILL
    null,
    @COURSEID,
    @ID,
    @CHANGEAGENTID,
    @STUDENTSKILLRATINGGROUPID,
    @NAME,
    @STARTDATE,
    @ENDDATE,
    @STUDENTSKILLMARKINGCOLUMNS

return 0