I have a classic ASP application for student grading with a paper (with an ID and a userID) that requires a grade and scores from several different criteria (criteria 1, score 1, criteria 2, score 2)
I wonder if I should put this in XML and push it into SQL Server as XML or convert the name/value pairs to a delimited string and just parse it out within the stored proc.
The data structure looks like this:
<DocumentCriteria> <Document grader="95" documentGUID="{B49654E7-9AF2-4B89-AF8F-5146F7CD4911}" graderFYC="5907"><criterion cnumber="1" rank="3"/><criterion cnumber="3" rank="3"/></Document></DocumentCriteria>'