Viewing 15 posts - 16 through 30 (of 43 total)
Scott:
Thank you for your reply. What did I miss?
Invalid column name 'jmoCompletedProductionHours'.
Steve Anderson
March 25, 2021 at 5:37 pm
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...
Steve Anderson
March 25, 2021 at 5:22 pm
Ok, great Tuturial!
https://qa.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
Steve Anderson
March 12, 2021 at 6:54 pm
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...
Steve Anderson
February 17, 2021 at 8:22 pm
This was removed by the editor as SPAM
January 5, 2021 at 2:41 pm
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?
Steve Anderson
October 21, 2020 at 5:07 pm
Thank you!
Steve Anderson
August 25, 2020 at 6:48 pm
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...
Steve Anderson
August 25, 2020 at 6:30 pm
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!
Steve Anderson
July 8, 2020 at 1:46 pm
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...
Steve Anderson
June 2, 2020 at 9:02 pm
Simply amazing!!
My next question is, is there a good book you would recommend to teach me all these tricks?
Thank you!!
Steve Anderson
May 6, 2020 at 1:41 pm
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...
Steve Anderson
November 25, 2019 at 5:38 pm
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...
Steve Anderson
November 25, 2019 at 4:58 pm
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
Steve Anderson
November 25, 2019 at 4:42 pm
Viewing 15 posts - 16 through 30 (of 43 total)