Doesn't seem to be "automatically scalable" unless you create the views and the trigger dynamically.  Maybe that doesn't matter much... non-dynamic solutions do require some human intervention but they usually run better...

Use the other form of case...

, SUM( CASE WHEN r.packagetransmethodid NOT IN (1,2,3,4,5,6,7,8,9) THEN ShipmentQty ELSE 0 END) as "Others"

I've just got to start selling the "T"-Shirts that say...

 SELECT *

   FROM Users

  WHERE Clue > 0

(0 row(s) affected)

Jono,

You should probably be a bit disgusted with...

I love it... Spot on, Serqiy.

First of all, the format of the date just about doesn't matter here (EXCEPT FOR THE FACT THAT YOU HAVE MIXED US AND EUROPEAN DATES!!! ARG!!)... it can be any...

I can't help but wonder why you would have multiple databases on the same server that need the same information.  Why aren't these databases all looking at the same data? ...

I agree with John.  It's easy... just tell it like it is... "Battle hardened SQL Server DBA with xx years of experience."  You never said you had a certification or not. ...

Here! Here!  I whole-heartedly agree.  While I have seen a few folks (very few) with certifications that are actually good, they seem to be far and few between, at least in...

Not nearly as stupid as trying to emulate spreadsheets in a database, eh?   Should'a listened to you on THAT one...

Thanks again, Serqiy.

Oh... when you said "Did you try to be dummy?", I didn't realize I had to be THAT dumb to get this to work 

Thanks for trying, Serqiy... the tab gets converted to "~WRF0409.tmp" when pasted back into a CMD window.  Have tried ALT-0-9, Ctrl-I, etc... all have the same effect.  And, haven't been able...

Great... thanks for the feedback.

This is just a bit of frustration talking but it's amazing to me that the original post asked for how to solve the "Min of 3" problem and changed to...