Comma separted string into list of distinct values

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 2005 Forums

Transact-SQL (2005)

Comma separted string into list of distinct values

Author

Topic

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2012-12-20 : 09:01:02

I have a table with some SEO keywords like

Data

ABC, def
ABC,
KLMNOPQ
OPQR, DEF

I needed a query which will give me result like

ABC
def
KLMNOPQ
OPQR

Kamran Shahid
Principle Engineer Development
(MCSD.Net,MCPD.net)

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2012-12-20 : 09:46:56

have found solution at http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/51e1d162-81d1-44e7-95f5-db0992c5809f

Kamran Shahid
Principle Engineer Development
(MCSD.Net,MCPD.net)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources