Click here to Skip to main content
12,632,477 members (33,946 online)
Click here to Skip to main content

Tagged as

Stats

0 views
Posted

How to split the values in sqlserver 2008

, 3 Oct 2012 CPOL
Hi Nanda Kishore, Try this code blockWITH SplitCTE AS (SELECT CAST('' + REPLACE(DelimitedColumn, ',','') + '' AS XML) AS StringsFROM YourTableName WHERE )-- Xquery to get the desired result set using CROSS JOINSELECT SUBSTRING(x.i.value('.',...

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 2-Oct-12 20:09 Available damodara naidu betha
Updates in content. 6 changes had been made.
1 No 2-Oct-12 20:06 Available damodara naidu betha

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

damodara naidu betha
Software Developer (Senior)
India India
No Biography provided

You may also be interested in...

Pro
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.161208.2 | Last Updated 3 Oct 2012
Article Copyright 2012 by damodara naidu betha
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid