SQLTeam.com | Weblogs | Forums

Csv data split to different columns


#1

id data


1 a,b,c
2 d,e,f,g,h
3 i,j,k

desired output

id data_1 data_2 data_3 data_4


1 a b c null
2 d e f g,h
3 i j k null


#2

read: Tally OH splitter and use that technique