I managed to come up with a solution. I don't know if it's the best but it will work. Basically we have an import utility that imported the...

It's Monday morning and I'm backed to my problem. I don't know if I need to adjust the script, create another one, or use two to get the task...

I didn't find anything on how to create the column headings but I didnt even know about BCP so that was a help.

I still need the column headings to go...

I have tried the following combinations and still nothing is working. A couple of them will query ok but will not execute.

select fnSplitMsg[msg])... /quote]

-- gives me this message ...

I don't think this will work because the number of items after the \ isn't always the same. Items will be added at the end of the string so...

I'm usting SQL 2000 and heres the link. It was actually anothor site.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92385

That doesn't work either.

I tried

select fnSplitMsg([msg]) from v_header_msg and now I

get the message:

Server: Msg 195, Level 15, State 10, Line 1

'fnSplitMsg' is not a recognized function name.

But...

I'm pretty new to SQL but have you tried aliasing the second starttime?