Thank you!

Scott:

Thank you for your reply.  What did I miss?

Invalid column name 'jmoCompletedProductionHours'.

Thanks for your reply.

I actually tried this.  It is summing the hours not by the PartID in the Job, but by the job, so it appears.  Every row for the...

Ok, great Tuturial!

https://www.sqlservercentral.com/articles/postgresql-where-order-by-and-group-by-clauses

SELECT EmpNo, SUM(Time1) AS TotalTime, Dept, Job, Description, Rework

FROM TimeData2

GROUP BY EmpNo, Dept, Job, Description, Rework

Got it:

But if you have a good tutorial on INNER Joins and Group By's it would be appreciated.

SELECT D.DocumentID AS [Document ID], XR.XRefDocument AS [Child Document ID], MAX(XR.RevNr) AS [Rev...

Jeffrey:

I have to be honest, over the last 90 days I have received over 500 emails from you on these posts.  How is this possible?

Thank you!

Hello:

Just one more thing,  how to I get a display of fewer decimals?  It seems to want to show 8 plus decimals, even if I apply round, just converting them...

OK, THIS IS RIDICULOUS!  I NEVER SIGNED UP TO FOLLOW THIS POST, YET I HAVE HUNDREDS OF EMAILS ON IT.  GET ME OFF THIS POST PLEASE!

I played around with the query a little and added percentage columns.

The math works, but it seems to default to six decimal places.  100% - 100.000000. Is there a way...

Simply amazing!!

My next question is, is there a good book you would recommend to teach me all these tricks?

Thank you!!

Populate data vs show data, my dilemma is that I see no data for my query at all.  I don't agree that this should be the case, unless there is...

This is great because yes, it runs but populates no data.

Tried this as well:

SELECT T1.JobNo, T1.ActualHrs, T1.ReworkHrs , T2.Time, T2.Rework

FROM JobSheet.dbo.JobHrs T1

INNER JOIN TimeReporting.dbo.TimeData T2 ON T1.JobNo = T2.JobNo

WHERE T1.JobNo...

Thank you.l  This is what I ended up with!

SELECT EmpNo, Date1, SUM(Time) AS TotalTime

FROM TimeData

WHERE (EmpNo = @EmpNo) AND (Date1 = @Date)

GROUP BY Date1, EmpNo