Thank you
Aragon<code>
,
A small difference from the above query
Remove "As E1" and "As E2"
ie,
SELECT CASE WHEN CONVERT(DECIMAL(18,3), ISNULL(CAST(60 AS DECIMAL(18,3))/CAST( 30 AS DECIMAL(18,3)),0))* 100 > 100 THEN 100 ELSE CONVERT(DECIMAL(18,3), ISNULL(CAST(60 AS DECIMAL(18,3))/CAST( 30 AS DECIMAL(18,3)),0))* 100 END AS Efficiency
FROM ProductionResultDisplyMst PRDM
JOIN (SELECT PRDMID, SUM(Actual) Actual, SUM(Plans) Plans FROM ProductionResultDisplyDtls
WHERE PRDMID IN (SELECT ID FROM ProductionResultDisplyMst WHERE PlantID=2
AND StageID IN(2 ,3, 4, 5) AND shift=2)
GROUP BY PRDMID ) PRDD
ON PRDD.PRDMID = PRDM.ID
JOIN StageMaster SM ON SM.StageID = PRDM.StageID
WHERE PRDM.STAGEID IN (2,3, 4, 5)
AND PRDM.PlantID = 2 AND PRDM.Shift = 2
AND CONVERT(VARCHAR(10), PRDM.ProductionDate, 120) = CONVERT(VARCHAR(10), GETDATE(), 120)
Thank you guys.........