Comma Seperated values into columns

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)

Comma Seperated values into columns

Author

Topic

Kalaiselvan
Posting Yak Master

112 Posts

Posted - 2011-08-05 : 09:28:26

Hi,
I got a column [VALUES] with values A,B,C.

Need this column as 3 rows. Like
[VALUES]
A
B
C

Please help me in this ASAP..

Regards,
Kalaiselvan R
Love Yourself First....

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-08-05 : 13:59:46

Look at the links under this section:
CSV / Splitting delimited lists

from here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources