in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » split (RSS)

Browse by Tags

  • 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 his approach he has limited it to maximum of four...
    Posted to Madhivanan (Weblog) by Madhivanan on Thu, Sep 11 2008
  • Splitting csv to columns

    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 ) select @s = 'this,is,test' select @data = '''' ...
    Posted to Madhivanan (Weblog) by Madhivanan on Sat, Mar 15 2008
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems