Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select Statement that groups a group? I don't know how to ask.
This is what I finally ended up using thanks to Naom in the asp.net forums. SELECT MyTable2.ProjectID, Projects.ProjectName, MyTable2.MgtHrs, MyTable2.RHrs, MyTable2.WHrs, MyTable2.TOTALHOUR, MyTable2.UserNameFrom(SELECT ProjectID, MAX(MgtHrs) as MgtHrs, MAX(RHrs) as RHrs, SUM(WHrs) as... -
Select Statement that groups a group? I don't know how to ask.
Ok, Can you help me take this farther? This query below partially works. The only two problems I have is that I can't return the ProjectName, which I know is easy. But most importantly, the MgtHrs is showing the Resource hours for the project no matter who the Manager is. I need to show... -
Select Statement that groups a group? I don't know how to ask.
wow r937, You are everywhere. Thank you again. -
Select Statement that groups a group? I don't know how to ask.
Select PID, ProjectName, UserName, Sum(Hours) From WorkLog WorkLog: PID | projectName | UserName | HourS | ---------------------------------------- 1 | Fist Project | Joe User | 2 | 1 | Fist Project | Joe User | 1 | 1 | Fist Project | BOB Cool | 2 | 2 | Second...
