SQL Syntax question
Posted on 2009-02-24
I have posted something similiar to this before. I have 1 row with an AccountID, Code and QTY. The accountid only has one value but the code and qty columns contain x number of values ';' delimited. I need the accountid, codes and qty columns parsed out for each one of the codes and qty columns into there own rows. Is there an easier way? I am trying to stay away from cursors but whatever will work I am willing to use. Please help!!