Forum ERP XL

Kod: Zaznacz cały

SELECT
    FORMAT(
        SUM(
            ROUND(WartoscGrupy * (1 + StawkaGrupy * 0.01), 2))
            , 'N', 'pl-PL') 
            AS [ Wartość Brutto ]
FROM
    (
        SELECT
            ZaE_StawkaPod as StawkaGrupy,
            SUM(ZaE_WartoscPoRabacie) AS WartoscGrupy
        FROM
            CDN.ZamElem
            JOIN CDN.ZamNag ON ZaN_GIDNumer = ZaE_GIDNumer
        where
            { filtrsql }
        GROUP BY
            ZaE_StawkaPod
    ) AS Grupy;