SELECT
Idx.IdxDateexp as 'Date',
round((sum(convert(float,Img.imgsize)) / sum(1)), 0) as 'Poids moyen en octets',
ISNULL( sum(1), 0) as 'Nombre de fichiers',
sum(convert(float,Img.imgsize)) as 'Volumétrie en octets'
FROM MABASE.[Images] Img
LEFT join MABASE.[IndexData] Idx ON Img.IdxId = Idx.IdxId
LEFT join MABASE.[NatureDoc] Nat ON Idx.NatId = Nat.NatId and Nat.NatName <> Nat.NatLib
and idxdateexp >=
CASE
WHEN Idx.IdxDateexp is null THEN 0
ELSE
dateadd(mm, -1, convert(datetime, '01'+right(convert(varchar, GETDATE(), 103), 8) + ' 00:00:00', 103))
END
group by Idx.IdxDateex
Partager