That look like that would work, and since the same criteria could be selected more than once, I can do distinct count on that temp table.

Thanks

for your help Max

I apologize for the errors.

This works but the number of criteria that could be selected could be a dozen or more. I won't know before hand. I was...

Thanks, I'll give that a shot.

Allen

There are more, could be lots more over time.

Allen

Yes, that works as well. I'll take a look at that explanation as well. It just seemed odd that it would round.

I read the explanation, now it makes...

After I change things back, how do I get the permissons for degging on my machine in Query Analyzer.  This is what started all this.

Thanks

I (you) got it working guys, thanks for all your help.

Allen

Thanks gova, I'll give it a shot and let you know how it works out.  Thanks for your input too Jason.

inv_id and partno are are what tie the two tables together.  In I_master table, the INV_ID is our internal part number and key for the table. The partno can be...

Jason, I ended up using the above with a few tweaks because of some data issues I did't expect.  I will try incorporating your new changes in. 

Thanks again for...

I beleive I have it now. I added another select on the outside

Select count(numberOfOrders),

COUNT(CASE WHEN (on_time + nullship) = 0 THEN 1 END) AS nullShip

from (

existing SQL

) tblCount

And this gives me...

Jason,

This almost gets what I want.  Where doing the most inner select, it shows on_time as 1 if that line item is late, which is good, but when summing up the...

Thanks Jason for all your effort, I'll give this a try and let you know how it goes.

Thanks

Allen

If any portion is late, the whole order is considered late.  As far as the invShip, it's not always populated, I'm trying to get a clarification on that myself.  It...

Most of the datsa comes from views but I have the data types.  The key on all these tables are identity columns.

TABLES:

soInfo.soNo char 6

soInfo.soKey char 6 + char 3 +...