How can calculate the sum of Man hours work end of week.
With group by projectno and sub group by dept

query is

SELECT BHOURS.BHOUR, MHOURS.NAME, MHOURS.PROJNO, MHOURS.DEPT, MHOURS.MHOURS
FROM BHOURS INNER JOIN MHOURS ON BHOURS.EMPNO = MHOURS.EMPNO;


TABLE BUDGETED HOUR
--------------------
empno ..varchar
name….varchar
dept….varchar
projno..varchar
bhour..nvarchar


TABLE MAN HOUR
------------------
empno varchar
name varharh
dated smaldatetime
projno varchar
dept….varchar
mhours..nvarchar

Please help to create query group by project no and sub group by
dept no ?

sum of each dept no man hour work ?



PROJECT NO. C2016
--------------------------------------------------
DEPT....NAME....BUDGETED MHOUR...MAN HOUR
---------------------------------------------------
HIGHWAY
........BULENT....170............17
........MARTIN....200............7

STRUCTURE
........ASOKAN....196............40
........STREETON..344............130
...
...




reagrds.

Mateen

*******Posted by Robvolk********************
Take a look in Books Online under "CUBE" and "ROLLUP". You may also want to look at "COMPUTE BY", but it is harder to work with and may be dropped in future releases of SQL Server. And it is usually better to perform multiple summarizations in a report rather than in a query.
********************************