Browse by Tags

All Tags » csv (RSS)

Splitting delimited data to columns - Set based approach

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...
Posted by Madhivanan | with no comments
Filed under: , , , ,

CSV to Multiple Columns

If the table is denormalised and has Comma Seperate Values in a column, this code will copy it to Multiple columns of a Normalised table declare @DeNormalisedTable table ( data varchar ( 8000 )) insert into @DeNormalisedTable select '1,Davolio,Nancy'...
Posted by Madhivanan | 2 comment(s)
Filed under: , ,