From: rodchar on 15 Apr 2010 17:52 thanks for the help, rod. "rodchar" wrote: > hi all, > > i'd like to take my single row result and turn selected columns into rows. > > id, col1, col2, col3 > --------------------- > 1, 10,20,30 > > > Desired result: > > new1, new2 > ---------------- > col1, 10 > col2, 20 > col3, 30 > > what's the easiest way to do this? > > thanks, > rodchar |