Chris,

I tested your latest post and yes, it does indeed calculate all sums correctly using the same test data set. There was one minor typo I wanted to mention...

Chris,

After some further experimentation I appear to have a working solution as shown below. Basically I adopted an inner query that I had tried from a previous attempt to...

Chris,

Thank you very much for your posted query. Unfortunately it overlooks one condition that I may not have made as clear as I should have. In the overall...

After some further experimentation I've gotten close (or so it seems) but not quite there. My latest attempt at this is shown below. The inner query (starting with...

Doug,

Thank you for your reply. The SQL compiler was not happy with the join clause movement that you had proposed. Nonetheless, your suggestion got me to thinking about...

Ken,

No problem. I actually learned more wrestling with that last query trying to make it work than I would have if it worked out of the box. Anyhow,...

Ken,

Thanks for the optional solution. I spent some time studying it and like it in that it seems conceptually fairly straightforward. I have not previously used the HAVING...

Thank you very much for your responses,

Ken, I tried your solution against my tables and it worked perfectly - the first time. I had never used derived tables, but...

Hello,

I had a chance to try out the suggestions.  Here's what I found...

Matt - the query you suggested below works.

UPDATE

inv

SET inv.

Hello,

Thank you all for all the feedback.

I had hoped to be able to try some of your suggestions this evening, but got derailed by other things.

I will have a go...

Matt,

Basically it is posting to too many records in the INV table. 

In the final where clause,

WHERE inv.class IN (SELECT class FROM issue_dx) AND inv.PartNumber IN (SELECT PartNumber...

Sorry - I managed to post before completing the message,

The above query fails in the WHERE clause of the main query.  The problem I am having is dealing with the...

John,

Thanks for the response.  I did some further rummaging around the SQL Server online help and ended up doing a complete rewrite of my query.  I came up with the...