var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Breaking up a string column into multiple records
Hopefully someone can help me. I have a table of records with the following fields:
now the multipleChoiceMultipleAnswer field data is in the following format:
I want to break that field up into multiple records using the same AnswerID and QuestionID for each new multiple choice answer, so it would look like this:
10001 1234 9999
10001 5678 9999
10001 99867 9999
10002 2345 9998
10002 456 9998
10002 7891 9998
Is there an optimized method of doing this without using a cursor to iterate through each record?
Any help would be greatly appreciated.
Look at the following link - if you need something else, let me know -