ali.prasla (10/29/2009)

---

I need some help in designing the table that can handle unbalanced/ragged hierarchy. What should be the table structure of below scenario? Below scenario entails that Bill is...

Have you checked the DTC configurations between Server2 and Server 3? You will find that through Admistrative Tools, Component Services.

Steve Jones - Editor (10/29/2009)

---

I think Gail is like me, running from thing to thing, not sure how all the plates are staying in the air.

At least I have kids...

Is it just me today or are OP's purposely posting things today that are as clear as mud?

I sorta figured that, but what he has posted just doesn't execute. 😉

Are the results of the query being written to a file? That could be the issue.

GSquared (10/29/2009)

---

Lynn Pettis (10/29/2009)

---

What is it with some people? I have seen sevarl threads where people are addressing others on their SSC Title instead of their forum name. like...

Explain further, please, what you are trying to accomplish. Your question does not make much sense.

What is it with some people? I have seen sevarl threads where people are addressing others on their SSC Title instead of their forum name. like GSquared.

Nothing this tells us, elaborate please.

mr_adeelalisyed (10/29/2009)

---

So here is my code if still people don’t understand what I am tying to do. The only catch is I changes @AD_TransactionErrorAuditSeqNum varchar(40) from varchar(30). This is another...

Here is my two cents.

(Have to post as an attachment, sorry.)

Bob Hovious 24601 (10/28/2009)

---

Grrrrrrrrrrr.... I can't get my mind back on work. Oldies tunes keep running through my head.

Some people call me the SQL Cowboy.

Some people...

Agree I must with Seth. Table DDL, sample data, expected results would greatly help. Plus, tested code you will receive in return.

The problem is in your code. Please note the changes I have made in both versions.

update temp_account set

balance01 = ta.balance01 + rs1.trans_amount

from

...