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 2000 Forums
 Transact-SQL (2000)
 how to insert into table reading from string

Author  Topic 

real_pearl
Posting Yak Master

106 Posts

Posted - 2004-09-17 : 13:03:49
This is the string 1,2,3,4,5,6
and I want to insert them into a temp table as 6 rows like

1
2
3
4
5
6



kselvia
Aged Yak Warrior

526 Posts

Posted - 2004-09-17 : 13:18:24
See this article for an example of how to do this: http://www.sqlteam.com/item.asp?ItemID=2652

--Ken
I want to die in my sleep like my grandfather, not screaming in terror like his passengers.
Go to Top of Page
   

- Advertisement -