What is the data type of the column involved?

Not doing this much, what I'd suggest is that you start by reading about FOR XML in Books Online, the SQL Server help System.

This may make what you are doing...

How many times do you plan on posting this???

Multiple post, please post responses here.

Multiple post, please post responses here.

Multiple post, please post responses here.

Multiple post, please post responses here.

Jeff Moden (7/30/2009)

---

Thanks Lynn. I know where the EULA's are... I was trying to spike some curiosity on the part of the OP.

As a side bar, the...

venu_ksheerasagaram (7/30/2009)

---

Hi Friends,

Here i am facing a big problem. I need your ideas and advices to overcome this.

I am having a database in which its Data file (.mdf...

Thank you for demonstrating your lack of maturity. You obviously have continued to argue when there is obviously no way you will convice me you are right.

mtucker (7/30/2009)

---

Lynn Pettis (7/30/2009)

---

mtucker (7/30/2009)

---

Unfortunately that fact that there is no scientific proof that God exists DOES NOT mean he does not exist, as there is no scientific proof for...

But, I also think this is what you are looking for:

create table #foo (

accountID int

, headerID int

, headerText varchar(40)

);

insert into #foo(accountID, headerID, headerText)

select 1, 1,...

I'm only missing one thing to really help you, what is the expected results based on the sample data provided above?

Jeff, since you want to see it in writing, check this path on your system at home, you should fing a copy of the EULA for the developers edition there:

C:\Program...

mtucker (7/30/2009)

---

Since it's impossible to prove the non-existence of diety, the denial of said existence is just as much a question of faith as the assertion of the opposite. ...

How about showing us what you did to fix the problem? Someone else may have a similar problem and seeing what you did may help.