Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Using CHARINDEX

Author  Topic 

JanakiRam
Starting Member

22 Posts

Posted - 2013-06-21 : 00:51:26
Hi.,

I need a query for below mentioned example

Declare @String VARCHAR(MAX)
SELECT @String = '1,125,22,256,88888,25,8888888'

This variable split the value after the comma separator then each values will display new record.

JanakiRam

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-06-21 : 01:16:00
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830&SearchTerms=CSVTable
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -