Yes Flo,

That makes sense, I was definitely having issues with the amount of time it would take and see that a web page is probably not the way to go...

I would *like* to give certain feedbacks to the person - (although it could probably all be automatic) like:

first query is more of a BCP import --> I would like...

OK, Thanks Gail

Yes, thank you, I checked the logs and it gave times and actions about recovering, it is restored now, phew!!!

Incredible,

The update query worked perfectly, now to spend the next couple of hours studying why...

Thank you very much, it scares me that I would never have been able to come...

Wow,

So, since I already have my tables, and I want to create just the query... do I start with your statement here:

;with Concatenated (Store, Audits) as --- "Common Table...

OK Thanks

I'll google and learn about "update from"

I assume you are saying yes, it can be done in one query (the "update from" being the first part of the query...)

Thank...

errr...

That query gives output exactly what I was looking for...

what I can't understand is how to use the results of "no column name" as the updated field (prior_audits) in...

Thank you,

That is an awesome query, I will work on trying to understand it - never even heard of "stuff"

I understand your concerns on the 2 tables however I...

Thank you - but I think I got something simpler, I took out the other conversion stuff and "cast as money" that field (amtdue)and it seemed to work

Well yes, that is definitely a direction however, I am afraid of making this a very powerful user since it will be eventually a web query, just wondering if there...