hello
i have these three updates
do you know how to do them faster?
thank you
</
Failures_TOTAL_exklNA =
(SELECT COUNT(*)
FROM AQIs.dbo.Alle_Fehlerdaten
WHERE LEFT(CONVERT(NVARCHAR, [BV-05], 120), 10) = AMPPU_Fehlerdaten_CalcVals.Offline_DATE
AND RIGHT(Fehlercode,1) IN ('4','5')
AND [BV-05_Monat] = MONTH(GETDATE())
AND [BV-05_Jahr] = YEAR(GETDATE())
AND CASE WHEN Zeit_Fehler_AUS IS NULL THEN 'No'
WHEN [BV-05] >= Zeit_Fehler_AUS THEN 'Yes'
ELSE 'No' END = 'NO')
WHERE MONTH(Offline_date) = MONTH(GETDATE())
AND YEAR(Offline_date) = YEAR(GETDATE());
UPDATE AMPPU_Fehlerdaten_CalcVals
SET
Failures_TOTAL_inklNA =
(SELECT COUNT(*)
FROM AQIs.dbo.Alle_Fehlerdaten
WHERE LEFT(CONVERT(NVARCHAR, [BV-05], 120), 10) = AMPPU_Fehlerdaten_CalcVals.Offline_DATE
AND RIGHT(Fehlercode,1) IN ('4','5')
AND [BV-05_Monat] = MONTH(GETDATE())
AND [BV-05_Jahr] = YEAR(GETDATE()))
WHERE MONTH(Offline_date) = MONTH(GETDATE())
AND YEAR(Offline_date) = YEAR(GETDATE());
--
UPDATE AMPPU_Fehlerdaten_CalcVals
SET
Orders_DailyVolume =
(SELECT COUNT(Auftrag_Nummer)
FROM Auftrags_Info
WHERE LEFT(CONVERT(NVARCHAR, Datum_Pfase_7, 120), 10) = AMPPU_Fehlerdaten_CalcVals.offline_Date
--AND MONTH(Datum_Pfase_7) = MONTH(GETDATE())
AND YEAR(Datum_Pfase_7) = YEAR(GETDATE()))
WHERE MONTH(Offline_date) = MONTH(GETDATE())
AND YEAR(Offline_date) = YEAR(GETDATE());
/>