It could be the database server, it could be your web server. You are going to have to do some troubling shooting to determine what the problem is. ...

Not being a CommerceServer expert, what I saw in one of the errors indicated that it may have lost connection to the database server.

Simple answer, write it both ways and test. Use the one that works best for you. You may want to revisit the testing periodically to see if there...

I just have to be sure here, your production databases are simply read-only databases except when there is an update. No data is being inserted, updated, or deleted on...

Providing us with your code is the first step, but we need more to really help you. It would help if you provided the DDL (CREATE TABLE statements) for...

I'm trying figure out what you are attempting to accomplish. Are you restoring a current copy of a database to stage, applying updates that need to go into production...

I did a cut and paste of the code above, and had no issues with it.

We didn't get a lot of snow down here in the banana belt (Fountain Valley Region). Took an hour to get home yesterday in the storm though. We...

Well, I think Steve answered...

Jeff Moden (3/26/2009)

---

Lynn Pettis (3/26/2009)

---

Having found out he lives in Denver, we just need to get him to start attending the SQL Server Users Group meetings up there. Perhaps...

Okay.... Actually, I may have seen the movie mentioned in wikipedia, but I haven't read any of the books mentioned. i must be missing something good!

notes4we (3/26/2009)

---

Lynn Pettis (3/26/2009)

---

Changing methods a bit here, so here is some test code for you to play around with:

create table #TestTab2 (

Dept ...

And I really have to ask, what is a fnords?

Uh, Bob, it's right there next to the button to send someone a Private Message. 😉

Okay, I know it snowing here now, but you may want to wait before...

Compare the data in #TestTab1 to the data in #TestTab2. You will see that the subtraction is occurring.