Sorry, Remi... that wasn't directed at you... I got so ticked at the mere suggestion that such a simple data manipulation be done...

 Ok... I know... "put up or shut up, Jeff"... fine Let's see you do it any simpler in an app

I try to use my memory... but I forget...

Serqiy... You really that old ?

If there are dupes on a,b, or d... whatcha wanna do?  Just grab anything?  Not exactly a good database practice but it helps...

WHY?  The code won't be any simpler there!

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...