mercredi 29 juin 2016

SQL Server, split column values for every 10 strings

Need to split the column Reference values for every 10 characters and need to show it for every row ID

I have data like this

ID       Reference
1        405123  ap41502   ag067156
2        a450912   d109456
3        4a4122   g567412  ol09123  pl212671 et61789
4        6t3450   41234a3   01a459014

Required Result:

ID  Reference
1   405123  ap
1   41502   ag
1   067156
2   a450912   
2   d109456
3   4a4122   g
3   567412  ol
3   09123  pl2
3   12671 et61
3   789
4   6t3450   4
4   1234a3   0
4   1a459014

Aucun commentaire:

Enregistrer un commentaire