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
 SQL Server Development (2000)
 Separate value form field to row SQL Server 2000

Author  Topic 

lonjovy
Starting Member

2 Posts

Posted - 2010-07-10 : 07:10:57
So,please help me to split value from table like below

field A has value below

13974;14098;14237;14269;14317;14319;14392;14393;13 257;13983;13820

and i need to split and down value in row like below

file B
13974
14098
14237
14269
....
please help me to supports many thanks

cuz, i need to use value to join other tables.

sathiesh2005
Yak Posting Veteran

85 Posts

Posted - 2010-07-10 : 07:36:42
try this.
http://geekswithblogs.net/angeleyes/archive/2007/04/12/111504.aspx

@Sathiesh
Go to Top of Page

lonjovy
Starting Member

2 Posts

Posted - 2010-07-10 : 09:04:52
thanks @Sathiesh i'll try to applied.
Go to Top of Page
   

- Advertisement -