horizontal to vertical in one field data - SQL

Asked Jan 20 '18 at 04:49

Active Jan 20 '18 at 05:33

Viewed 24 times

I have data in one field separated by comma "ID field " and I need to write each number in one column vertically the data as below:

YEAR   WEEK BADGE   Name    remarks         BT_Hrs  NoOfDays    id
2017    1   1111    emp1    test1            36       4         440,824,104,412,741,900,000

the table needed as below

2017    1   1111    emp1    test1   36  4   440
2017    1   1111    emp1    test1   36  4   824
2017    1   1111    emp1    test1   36  4   104
2017    1   1111    emp1    test1   36  4   412
2017    1   1111    emp1    test1   36  4   741
2017    1   1111    emp1    test1   36  4   900
2017    1   1111    emp1    test1   36  4   000

edited Jan 20 '18 at 05:33

asked Jan 20 '18 at 04:49

osama

Please show your expected output and the query you have tried. – Jinesh Shah Jan 20 '18 at 05:07
@JINESHSHAH I have edited the question pls check. – osama Jan 20 '18 at 05:34
i solve it thanks with XML and CROSS APPLY – osama Jan 22 '18 at 09:14
https://stackoverflow.com/a/46772257/3623517 – osama Jan 22 '18 at 09:14

horizontal to vertical in one field data - SQL

0 Answers0