jeudi 16 avril 2015

How do i put my whole querry in a stored Procedure?


Select
AvHours.LineNumber,
(SProd.PoundsMade / (AvHours.AvailableHRS - SUM (ProdDtime.DownTimeHRS))) AS Throughput,
SUM (ProdDtime.DownTimeHRS) AS [Lost Time],
(SUM(cast(ProdDtime.DownTimeHRS AS decimal(10,1))) * 100) / (cast(AvHours.AvailableHRS AS decimal(10,1))) AS [%DownTime],
SUM(SProd.PoundsMade) AS [Pounds Made],
(SProd.PoundsMade / (AvHours.AvailableHRS - SUM (ProdDtime.DownTimeHRS))) * SUM (ProdDtime.DownTimeHRS) AS [Pounds Lost]


FROM rpt_Line_Shift_AvailableHrs AvHours inner join rpt_Line_Shift_Prod SProd on AvHours.LineNumber=SProd.LineNumber AND AvHours.Shiftnumber=SProd.Shiftnumber inner join rpt_Line_Shift_ProdDownTime ProdDtime on (AvHours.LineNumber=ProdDtime.LineNumber AND AvHours.Shiftnumber=ProdDtime.Shiftnumber) GROUP BY AvHours.LineNumber,SProd.PoundsMade,AvHours.AvailableHRS ORDER BY AvHours.LineNumber


Aucun commentaire:

Enregistrer un commentaire