Witam,
Od dłuższego czasu posiadamy ten oto SQL
SELECT tw_Nazwa AS [Nazwa], tw_Symbol AS [Symbol], grt_Nazwa AS [Grupa], SUM(ob_IloscMag) AS [Ilość], tw_JednMiary AS [J.m.],
SUM(ob_WartBrutto) AS [Brutto], SUM(ob_WartNetto) AS [Netto], SUM(ob_WartMag) AS [Koszt], SUM(ob_WartNetto-ob_WartMag) AS [Zysk],
CASE WHEN SUM(ob_WartNetto) = 0 THEN 0 ELSE ROUND(100*SUM(ob_WartNetto-ob_WartMag)/SUM(ob_WartNetto), 2) END AS [Marża(%)]
FROM(
SELECT {D: Data od} AS data, F.dok_Id, F.dok_RodzajOperacjiVat, F.dok_Status, F.dok_MagId, F.dok_DataWyst, F.dok_NrPelny, F.dok_PlatnikId, M.dok_OdbiorcaId, F.dok_Typ, C.ob_NumerSeryjny, C.ob_Opis, C.ob_Rabat, B.ob_TowId,
C.ob_IloscMag+(B.ob_Znak*B.ob_IloscMag)+ISNULL(D.ob_IloscMag,0) AS ob_IloscMag, C.ob_WartNetto+(B.ob_Znak*B.ob_WartNetto)+ISNULL(D.ob_WartNetto,0) AS ob_WartNetto,
C.ob_WartBrutto+(B.ob_Znak*B.ob_WartBrutto)+ISNULL(D.ob_WartBrutto,0) AS ob_WartBrutto,
CASE WHEN (C.ob_TowRodzaj&6)>0 THEN 0 ELSE dbo.fnZestSub_KosztSpr({D: do}, C.ob_Id)*C.ob_Znak END AS ob_WartMag
FROM dok__Dokument F
INNER JOIN dok__Dokument M ON M.dok_DoDokId = F.dok_Id
INNER JOIN dok_Pozycja C ON C.ob_DokMagId = M.dok_Id
LEFT JOIN (SELECT ob_DoId, SUM(ob_Znak*ob_IloscMag) AS ob_IloscMag, SUM(ob_Znak*ob_WartNetto) AS ob_WartNetto, SUM(ob_Znak*ob_WartBrutto) AS ob_WartBrutto
FROM dok_Pozycja WHERE ob_Status=2 GROUP BY ob_DoId) D ON C.ob_Id = D.ob_DoId
INNER JOIN dok_Pozycja B ON C.ob_Id = B.ob_Doid
INNER JOIN tw_Cena ON B.ob_TowId = tc_IdTowar
WHERE F.dok_Typ = 2 AND F.dok_Podtyp = 2 AND F.dok_Status = 1 AND B.ob_DokHanId = F.dok_Id AND C.ob_IloscMag+(B.ob_Znak*B.ob_IloscMag)+ISNULL(D.ob_IloscMag,0) <> 0
UNION ALL
SELECT {D: Data od} AS data, dok_Id, dok_RodzajOperacjiVat, dok_Status, dok_MagId, dok_DataWyst, dok_NrPelny, dok_PlatnikId, dok_OdbiorcaId, dok_Typ, ob_NumerSeryjny, ob_Opis, ob_Rabat, ob_TowId,
ob_IloscMag, ob_WartNetto, ob_WartBrutto, CASE WHEN (ob_TowRodzaj&6)>0 THEN 0 ELSE dbo.fnZestSub_KosztSpr({D: do}, ob_Id)*ob_Znak END AS ob_WartMag
FROM dok__Dokument
INNER JOIN dok_Pozycja ON ob_DokHanId = dok_Id
INNER JOIN tw_Cena ON ob_TowId = tc_IdTowar
WHERE ((dok_Typ = 2 AND dok_Podtyp = 2 AND ob_WartNetto <> 0 AND ob_DoId IS NULL) OR (dok_Typ = 2 AND dok_Podtyp = 0) OR (dok_Typ = 2 AND dok_Podtyp = 3 AND dok_StatusEx = 1) OR (dok_Typ = 2 AND dok_Podtyp = 5) OR dok_Typ = 62)
) k
INNER JOIN tw__Towar ON ob_TowId = tw_Id
LEFT JOIN sl_GrupaTw ON grt_Id = tw_IdGrupa
WHERE dok_DataWyst BETWEEN {D: Data od} AND {D: do}
AND dok_Id IN ({CHL_DB: SELECT dok_Id, dok_NrPelny AS Dokument FROM dok__Dokument WHERE dok_Typ=2 ORDER BY dok_DataWyst DESC, dok_Nr DESC:Faktura:0:wybierz})
AND tw_Id IN ({LM:TW:Towar})
GROUP BY tw_Nazwa, tw_Symbol, tw_JednMiary, grt_Nazwa
ORDER BY tw_Nazwa
I niestety przestał działać, nie znamy przyczyny, sam test do bazy przechodzi poprawnie ale samo uruchomienie tego SQL już wywołuje komunikat "błąd wykonania zapytania"
Co może być przyczyną problemu ?
