WITH tbl as
(
	SELECT 1 Val_Int UNION all
	SELECT 2 UNION all
	SELECT 2 UNION all
	SELECT 3 UNION all
	SELECT 7 UNION all
	SELECT 5
)
SELECT Pers,ISNULL(MAX(Val_Int),0) Mx,COUNT(Val_Int) Cnt FROM
(
	SELECT LAG(Val,1) OVER(ORDER BY Pers) PrevVal,Val,Pers FROM
	(
		SELECT Val,CAST(Pers AS INT) Pers
		FROM 
		(
			SELECT TOP 1 
				   PERCENTILE_CONT(0.1) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [10], 
				   PERCENTILE_CONT(0.2) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [20], 
				   PERCENTILE_CONT(0.3) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [30], 
				   PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [40], 
				   PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [50], 
				   PERCENTILE_CONT(0.6) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [60], 
				   PERCENTILE_CONT(0.7) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [70], 
				   PERCENTILE_CONT(0.8) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [80], 
				   PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [90], 
				   PERCENTILE_CONT(1) WITHIN GROUP (ORDER BY Val_Int) OVER (PARTITION BY 1/0) [100]
			FROM  tbl
		) upvt
		UNPIVOT(Val FOR Pers IN ([10],[20],[30],[40],[50],[60],[70],[80],[90],[100])) upvt
	) Z
) Z
LEFT JOIN tbl
	ON (tbl.Val_Int>PrevVal OR PrevVal IS NULL)
	AND  tbl.Val_Int <= Val
GROUP BY Pers

WITH tbl as
(
	SELECT 1 Val_Int UNION all
	SELECT 2 UNION all
	SELECT 2 UNION all
	SELECT 3 UNION all
	SELECT 7 UNION all
	SELECT 5
)
SELECT Pers,ISNULL(MAX(Val_Int),0) Mx,COUNT(Val_Int) Cnt FROM
(
	SELECT LAG(Val,1) OVER(ORDER BY Pers) PrevVal,Val,Pers FROM
	(
		SELECT Val,CAST(Pers AS INT) Pers
		FROM 
		(
			SELECT TOP 1 
				   PERCENTILE_CONT(0.1) WITHIN GROUP (ORDER BY Val_Int) OVER () [10], 
				   PERCENTILE_CONT(0.2) WITHIN GROUP (ORDER BY Val_Int) OVER () [20], 
				   PERCENTILE_CONT(0.3) WITHIN GROUP (ORDER BY Val_Int) OVER () [30], 
				   PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY Val_Int) OVER () [40], 
				   PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY Val_Int) OVER () [50], 
				   PERCENTILE_CONT(0.6) WITHIN GROUP (ORDER BY Val_Int) OVER () [60], 
				   PERCENTILE_CONT(0.7) WITHIN GROUP (ORDER BY Val_Int) OVER () [70], 
				   PERCENTILE_CONT(0.8) WITHIN GROUP (ORDER BY Val_Int) OVER () [80], 
				   PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY Val_Int) OVER () [90], 
				   PERCENTILE_CONT(1) WITHIN GROUP (ORDER BY Val_Int) OVER () [100]
			FROM  tbl
		) upvt
		UNPIVOT(Val FOR Pers IN ([10],[20],[30],[40],[50],[60],[70],[80],[90],[100])) upvt
	) Z
) Z
LEFT JOIN tbl
	ON (tbl.Val_Int>PrevVal OR PrevVal IS NULL)
	AND  tbl.Val_Int <= Val
GROUP BY Pers