oh, you're one to talk!! "I almost bought bad meat once..."   

Please follow Remi's links. 

Here is another way to code this, plus some comments and questions that should be resolved within this select: 

SELECT UdeptManager, Uname, IOofficeName AS Office,

       SUM(...

dekko

It was interesting - the first place I looked had no definition, but stated it was slang derived from England...

Agreed.  My 'guess' would be it is in the Joining of tables, though... 

Too many people want to cancel their subscriptions and then there's the "Slander" suits....  

The Daily SQL 

DBA's head explodes

In a strange twist of fate, a well known DBA, (Remi RGR'us) head exploded in a fog of smog.  Office workers...

Thanks sushila! Didn't grasp that one... 

Better do it.  She hasn't killed any body yet, but the day is not over...  

Wait a minute!  What is this one?  "I thought I screwed up, but I was mistaken"?   

"She who must be obeyed" is my wife.  Got that from a British serial on a judge. 

I thought that might happen and updated the post - not quick enough for Remi, though...  

A Big Mac?  Yeah, you gotta be careful where the meat comes from with those burgers...  

You know..., its amazing.  I can do it without even trying sometimes.  I will often come home and find out I am in trouble with "she who must be obeyed",...

You have excellent diplomacy skills Remi! 

(oh, crum...., do you think he will know I lie to him as well?) 

As a 'general' rule, you want to specify each individual column in your select, (as opposed to SELECT *), and bring all of the data to your application.  That way,...

Remi beat me... This is a presentation issue, hence my second select will give you the output you want, but that is not really a SQL Server job...  [I chose...