August 8, 2011 at 9:41 am
is it possible with new features in sql to do the following:
row1:1,2,3,'a,b,c',4
row2:1,2,3,'e',4
row3:1,2,3,'f,g',4
row4:1,2,3,'h',4
row5:1,2,3,'i,j,k',4
the above original table has to be transformed as
row1:1,2,3,'a',4
row2:1,2,3,'b',4
row3:1,2,3,'c',4
row4:1,2,3,'d',4
row5:1,2,3,'e',4
row6:1,2,3,'f',4
row7:1,2,3,'g',4
row8:1,2,3,'h',4
row9:1,2,3,'i',4
row10:1,2,3,'j',4
row11:1,2,3,'k',4
the original data is long and complex, but this is the idea. the items that needs broken down is a varchar string.
thanks
August 8, 2011 at 9:48 am
August 8, 2011 at 8:37 pm
Where is the 'd' coming from in your output set? Is it a typo?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply