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

Author  Topic 

s_a19
Starting Member

15 Posts

Posted - 2003-08-01 : 07:34:33
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

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-08-01 : 07:42:08
Please do not cross post:

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

- Advertisement -