Commando...

First, I gotta share the normal diatribe about your numeric sequence and forgive me while I blast the designer... if you were the designer, sorry, but not sorry...

Nicely done, Kim.

No sure what the "Number" parameter in Sybase is but...

There a multiple functions in SQL Server that return info about the current connection... for example... @@SPID returns the SPID of...

create an updateable passthrough view in each target database

I don't see where you said those words, but may that's what you meant...  I was talking about just creating...

Yep... I missed that one... guess it's time for some sleep

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.