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
 General SQL Server Forums
 Database Design and Application Architecture
 How to get split functionality in query

Author  Topic 

mrashish77
Starting Member

4 Posts

Posted - 2011-05-13 : 09:11:44
I am having one table with a delimited data column. i want to seperate the data in single query like split funtion.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-05-13 : 09:59:11
Have a look at this page: http://www.sqlservercentral.com/articles/Tally+Table/72993/ The post itself is very long, but you can scroll through if you like, copy and install the function in Fig. 21 on your database, and then use it.
Go to Top of Page
   

- Advertisement -