SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Using CHARINDEX
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JanakiRam
Starting Member

India
22 Posts

Posted - 06/21/2013 :  00:51:26  Show Profile  Reply with Quote
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)

Singapore
17636 Posts

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


KH
Time is always against us

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000