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.

Ignoring your query for the moment, what is the expected results from the query based on the sample data. In other words, what are we trying to accomplish with...

For those who haven't noticed, The BLOG button is now active on my posts. I now have a blog on SSC. 😉

GSquared (3/26/2009)

---

Lynn Pettis (3/26/2009)

---

It also makes me wonder what company he works for as well. Must not have much in the way of data or they'd probably be complaining...

Have you looked in the SQL Server Logs in the Management Folder in SSMS Obect Explorer?

Lowell has given you the principle you need to figure out what needs to be done. May I suggest you read up on GROUP BY in Books Onlie? ...