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 seperated list into columns

Author  Topic 

deepakugale
Starting Member

33 Posts

Posted - 2010-03-11 : 02:25:12
HI All ,

I have comma separated list like
1,12,22,3699,94,99,444,6566,5522,3
Want to insert each figure into table IDS which is having Id int as column ,want O/p like

Id
1
12
22
3699
94
99
444
6566
5522
3

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-03-11 : 02:29:29
make use of one of the following
CSVTable
fnParseList


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -