Not really, it's just that sometimes you are too close to a problem to see it clearly.

... AND Left(Zip, 5) IN ('98101','98104','98154')

🙂

Actually I was refering to the execution plan diffs. 

EDIT: Oh, and I agree with you on the previous...

Just for **** and giggles, I created a function zeroIsMinimum to handle the negative numbers and see how this affected performance. I got some pretty unusual results. now this may...

This should get you going. The challenge for you now is to understand HOW this works

DECLARE @table TABLE (someID INT IDENTITY(1,1),...

This will work ....

UPDATE i

    SET qty_on_hand =

        CASE WHEN qty_on_hand - (SELECT COUNT(*) FROM @workTable w WHERE w.partno = i.inv_ID) < 0 THEN 0

       ...

Yeah, but I don't account for negative values .....

Gimmie a minute though .....

Sorry, I missed the part about making negative results equal 0.

Oh, and whatever you need in the WHERE clause.

UPDATE i

    SET qty_on_hand = qty_on_hand - (SELECT COUNT(*) FROM @workTable w WHERE w.partno = i.inv_ID)

    FROM @I_master i

No need to cross post..

Create an aspx page that either shows your message or redirects to the Default.aspx of reporting services depending on the time of day. Set that as...

Create an aspx page that either shows your message or redirects to the Default.aspx of reporting services depending on the time of day. Set that as your default page in...

FYI to all, V posted more detail in PM. Below is the script that gave him the desired results...

/*

    SQL to create the temp tables for my testing...

Is there a Primary Key on this table? What is it? Please provide DDL.

Here's another way to skin the cat ....

Your table is "dbo.challenge"

SELECT

    colA

    ,SUM(colB)

FROM

    (SELECT

        a.colA

        ,colB...