Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT * FROM (SELECT b.Job, c.Work_Date, d .Type, a.Customer, a.Part_Number, a.Description, a.Rev, a.Top_Lvl_Job, b.Work_Center, b.Operation_Service, b.Description AS WC_Description, a.Profit_Pct, a.Commission_Pct, a.Unit_Price, a.Order_Quantity, b.Est_GA_Burden, b.Est_Machine_Burden, b.Est_Labor_Burden, b.Est_Run_Labor, b.Est_Setup_Labor, b.Act_GA_Burden, b.Act_Machine_Burden, b.Act_Labor_Burden, b.Act_Run_Labor, b.Act_Setup_Labor, a.Est_GA_Burden AS Total_Est_GA_Burden, a.Est_Machine_Burden AS Total_Est_Mach_Burden, a.Est_Labor_Burden AS Total_Est_Labor_Burden, a.Est_Service AS Total_Est_Service, a.Est_Material AS Total_Est_Material, a.Est_Labor AS Total_Est_Labor, a.Assembly_Level, a.Act_Material, a.Act_Service, c.Operation_Complete, row_number() OVER (partition BY b.Job, b.Work_center, b.Description ORDER BY c.Work_date) rn FROM dbo.Job a INNER JOIN dbo.Job_Operation b ON a.Job = b.Job INNER JOIN dbo.Job_Operation_Time c ON b.Job_Operation = c.Job_Operation INNER JOIN dbo.Work_Center d ON b.Work_Center = d .Work_Center WHERE c.Operation_Complete = 1) t1 WHERE rn = 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|point in time restore in SQL server||26||54|
|Problem with MySQL query - graph||3||46|
|MySql Linux vs Windows: bad results for Windows but why?||10||72|
|Importing from CSV to SSMS||2||11|
Join the community of 500,000 technology professionals and ask your questions.