Query non eseguita: The SELECT permission was denied on the object 'vServiziTotali', database 'alarico', schema 'dbo'. SELECT percentData.*, FLOOR((percentData.Erogato / percentData.Budget) * 100) as Perc
FROM
(
SELECT
tID.IDServizio as IDServizio,
sp.Anno as Anno,
ISNULL(sp.Preventivo,0) as Budget,
( ISNULL(sp.Impegnato,0) + ISNULL(s.impPAYED,0) + ISNULL(s.impTOPAY,0) ) as Erogato
FROM TServizi as tID
LEFT JOIN SPreventivi as sp on (tID.IDServizio = sp.IDServizio) and (sp.Anno = '2026')
LEFT JOIN vServiziTotali as s on (tID.IDServizio = s.IDServizio) and (s.AnnoCompetenza = '2026')
LEFT JOIN vServiziTotali as s2 on (tID.IDServizio = s2.IDServizio) and (s2.AnnoCompetenza = '2026')
where tID.IDServizio = '87'
) as percentData