The following query could form the basis of a CURSOR that could, for each row, execute the necessary SQL to check fragmentation, although I suspect you could probably just JOIN...

Views with UNION ALL in them and large row counts are always going to be problematic.   If you can't deconstruct the views within your stored procedure because your company insists...

Integer Math.    You have to do something to tell SQL Server that when it divides two integer values that you need a decimal result.   The only effective way to...

How about we add the YEAR to the GROUP BY ?   Here's some more formatted code for you:
DECLARE @DateFrom AS date = '20180101',
        @DateTo AS date = '20180821';

The biggest problem here is what value would one want when you have, say, 113/16"   ???   Is that 1 and 13/16, or is it 11 and 3/16 ???   If you...