Good catch!
>
>I haven't taken the luxury of actually trying this out, but it at least looks nice and sexy:
>>
>>http://www.devx.com/tips/Tip/17059 >
>The technique is useful, and added to my SQL knowlege. Thanks Jeff for posting the link.
>
>Comment: The result is more normalized, but not fully normalized: it has repeating Student_ID and StudentName fields. There should be another table with Student_ID and StudentName fields, and the StudentName field should be dropped from the existing SELECT. Coding that is left as an exercise for the reader. ;-)