Browse by Tags

• csv
• parsename
• pivot
• sql server
• T-SQL

Splitting delimited data to columns - Set based approach
11 September 08 12:58 PM | Madhivanan | 2 Comments   

In this post splitting-csv-to-columns I showed how to split delimited data into multiple columns Simon in his post Set-based-splitting-of-delimited-strings-to-columns showed how to use that in a set based approach which would work on a set of data.In Read More...

Filed under: sql server, pivot, T-SQL, split, csv

Splitting csv to columns
15 March 08 09:10 AM | Madhivanan | 2 Comments   

Suppose you have string in csv format and want to split into seperate columns. You can use parsename function as long as you have maximum four values. The following would work for any number of values declare @s varchar ( 2000 ), @data varchar ( 2000 Read More...

Filed under: sql server, parsename, T-SQL, split