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)
 CSV Column -seperating

Author  Topic 

willnewbie
Starting Member

5 Posts

Posted - 2003-01-30 : 06:20:37
Following several days of head banging, reading articles that are close to what I am looking to do then trying to adjust them to my requirements I find I am just lacking the knowledge to do so.

I would be very grateful for any input and will evelvate your postion to God of the Week/year within my office as Jeff was a little while ago.

The detail:

I have a table with a column called concatnames:

Surname;firstname;middlename;title;


I want to then create the columns of Surname, Firstname, Middlename, Title

This really is doing my nut in I have searched through the articles that relate to CSV and sadly due to my inability have failed to change to any sucess to handle this.

Many thanks for any input in advance.

Will.



willnewbie
Starting Member

5 Posts

Posted - 2003-01-30 : 10:59:28
I think I may have found something that is going to work

Many thanks to anyone who had begun to work on anything.

Will.

Go to Top of Page
   

- Advertisement -