Hai ragione anche te -)
Questo se aggiungo
-------------------
order by datepart(mm,CONVERT(date,DATF,105)) desc
---------------Column "MOVIMENTI.DATF" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.