UFN_STUDENTMARKINGCOLUMN_GETGRADES_FROMITEMLISTXML
Used to convert an xml string to a table based on UFN_STUDENTMARKINGCOLUMN_GETGRADES.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/2/2010 7:19:38 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_STUDENTMARKINGCOLUMN_GETGRADES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_STUDENTMARKINGCOLUMN_GETGRADES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT
T.c.value('(Class)[1]','nvarchar(20)') AS 'Class',
T.c.value('(ClassID)[1]','uniqueidentifier') AS 'ClassID',
T.c.value('(CourseGradingID)[1]','uniqueidentifier') AS 'CourseGradingID',
T.c.value('(CourseGradingMarkingColumnID)[1]','uniqueidentifier') AS 'CourseGradingMarkingColumnID',
T.c.value('(CourseID)[1]','uniqueidentifier') AS 'CourseID',
T.c.value('(CourseName)[1]','nvarchar(60)') AS 'CourseName',
T.c.value('(CourseShortID)[1]','nvarchar(12)') AS 'CourseShortID',
T.c.value('(Graded)[1]','tinyint') AS 'Graded',
T.c.value('(GradeTypeCode)[1]','tinyint') AS 'GradeTypeCode',
T.c.value('(HighestScoreAllowed)[1]','numeric(14, 2)') AS 'HighestScoreAllowed',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(LetterGrade)[1]','nvarchar(10)') AS 'LetterGrade',
T.c.value('(LowestScoreAllowed)[1]','numeric(14, 2)') AS 'LowestScoreAllowed',
T.c.value('(MarkingColumnSetID)[1]','uniqueidentifier') AS 'MarkingColumnSetID',
T.c.value('(MCDisplayName)[1]','nvarchar(10)') AS 'MCDisplayName',
T.c.value('(MCID)[1]','uniqueidentifier') AS 'MCID',
T.c.value('(MCSequence)[1]','int') AS 'MCSequence',
T.c.value('(NumericGrade)[1]','numeric(14, 2)') AS 'NumericGrade',
T.c.value('(StudentClassMeetingGroupID)[1]','uniqueidentifier') AS 'StudentClassMeetingGroupID',
T.c.value('(StudentClassMeetingGroupStatusCode)[1]','tinyint') AS 'StudentClassMeetingGroupStatusCode',
T.c.value('(StudentCourseID)[1]','uniqueidentifier') AS 'StudentCourseID',
T.c.value('(Teacher)[1]','nvarchar(1000)') AS 'Teacher',
T.c.value('(TranslationTableGradeID)[1]','uniqueidentifier') AS 'TranslationTableGradeID',
T.c.value('(TranslationTableID)[1]','uniqueidentifier') AS 'TranslationTableID',
T.c.value('(ValuesAllowedCode)[1]','tinyint') AS 'ValuesAllowedCode',
T.c.value('(WithdrawalDate)[1]','date') AS 'WithdrawalDate'
FROM @ITEMLISTXML.nodes('/STUDENTGRADEINFO/ITEM') T(c)
)