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)
 transferring one column into several

Author  Topic 

s_a19
Starting Member

15 Posts

Posted - 2003-08-01 : 07:26:41
hy everyone, im having this problem

i am transferring data from one table to another table, but there is compatability issues, as in one table, this is contact which can have numerous amounts in, usually less than 3 people, for example

S Scott, Mr Scott Smith, Scott Smith

as you can see they are in different formats, but are always seperated by a comma, the above is only an example and can be different people

and i need to transfer it, into another table.
with title
inits
name
surname

as the requirements.

this one has me seriously stumped.

thanx(if anyone needs more descriptio, please ask)

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-08-01 : 07:42:43
echo off

Jay White
{0}
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-08-01 : 07:43:24
Once again, PLEASE DO NOT CROSS POST

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28159
Go to Top of Page
   

- Advertisement -