Thank you for your help

Here is the code as written by rsharma's 

but with some modification since the empid and deptid are not unique in the table

---------------------------------

set nocount on

go

Not so simple as that I want it to be more  general .

The departments may be passed by a parameter or to be in another table (they are unknown)

I put these figures to...