Iterate through column values

Asked Jul 04 '19 at 14:44

Active Jul 04 '19 at 14:45

Viewed 26 times

My user table has a column that contains comma seperated values, as each user can have multiple accounts. Please note that I can not change this structure.

UserID  | Accounts  
---------------------
1       | ABC,DEF,GHI
2       | JKL, MNO

Based on this table, I need to create a new table that contains one row for each account:

UserID  | Account   
---------------------
1       | ABC
1       | DEF
1       | GHI
2       | JKL
2       | MNO

edited Jul 04 '19 at 14:45

asked Jul 04 '19 at 14:44

shudder

Hint: `STRING_SPLIT()`. – Gordon Linoff Jul 04 '19 at 14:45
https://stackoverflow.com/search?q=%5Bsql-server%5D+split+string+to+rows – Jul 04 '19 at 14:45
`STRING_SPLIT()` is not availabe in the version of SQL I am stuck with – shudder Jul 04 '19 at 14:50
Check the duplicate link for a number of other options. The best thing to do might be to not even bring CSV data into SQL Server in the first place. – Tim Biegeleisen Jul 04 '19 at 14:53
1

If you can't create a Table-Valued Function, take a peek at Option 2 ... without UDF https://stackoverflow.com/questions/41999151/split-semicolon-delimiter-sql-to-rows/41999472#41999472 – John Cappelletti Jul 04 '19 at 14:57

Iterate through column values

0 Answers0