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

...

Looks like you need to setup linked servers to your Access databases. You can find more information about those in BOL 9Books Online, the SQL Server Help System). ...

To truely help you, more we need. Please provide the DDL (CREATE TABLE statements), sample data (INSERT INTO statements), and expected results based on sample data.

For help with this...

Well, yes, an error it is. Without know more, not much more we can do.

What are the source and destination data types being used?

I'm not sure about the file system compression. Before we purchased HyperBac, I was compressing the backup files using PKZip to reduce the amount of disk space used by...