Click here to Skip to main content
14,691,047 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,
i have a query with 1 column as comma separated values(CSVs). I want a query which will split this column in multiple columns without split function. I cant add function on DB which i am working on.The column may contain random CSVs i.e. some row may have 2 CSVs and some may have 5. Please suggest.
Posted
Updated 28-Dec-14 23:24pm
v2

1 solution

Here is an example[^], which uses CTE[^] to split delimited text into several rows.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900