Oops, yeah it does. Ignore my earlier comments about the extra piece, I keep misreading STUFF.:blink:

As a side note, the...

Can your data include commas as well? Let's have a for instance:

ID TXT

1 This is my first line of data, isn't it awesome?

1...

Jeff Moden (11/14/2008)

---

Heh... firing porkchop #1... [font="Arial Black"]SLAP![/font] 😛 Ya gotta put a clustered index or,...

Dooza (11/14/2008)

---

The key thing here for me is making sure the data is correct in the first place. Creating this function has brought to my attention all the variations and...

Yeah, I have a bad habit of "skimming" what people say and just looking at their code. Also, remember that these things will always be limited on what they...

You CAN do this with the following code. However, please note that it's not necessarily a good idea. Can you explain the reason this is needed?

INSERT INTO TableB(TAmount,GAmount,PAmount)

SELECT...

Hah. Great minds think alike! (Although, I'm sure dumb people think alike too, so let's hope we fit the first category).

First, allow me to state that this isn't a good idea in the first place. Those numbers should be stripped out of that field and put in a new...

Raises Hand. But... just me. Not like... other people. Those guys screw everything up. 😉

Is the list of columns to be concatenated dynamic, or is it a fixed list? (IE. it will only ever be columns A,B,C,D,E, and you only want to see...

Thanks for the feedback Art, glad we could help.

Your join seems wrong. (Without knowing what your data/table structure is, I can't say that it IS wrong, but to me it looks wrong)

Do you have an EmployeeID in...

I was originally thinking of using FOR XML PATH as well, but the TEXT references and the varchar(max) made me worry about getting the commas in there properly.

Todd,...

Paul,

Since you seem to be unwilling to read the post we've tried to send you to a dozen times so far, let me sum up the gist of...

Please refer to the link in my signature for how to post table structure/sample data here.