SELECT RN10, RN100, COUNT(*) FROM 
(
	SELECT RN, RN/10 AS RN10, RN/100 AS RN100 FROM 
	(
		SELECT RN = -1 + ROW_NUMBER() OVER (ORDER BY 1/0) FROM master..spt_values
	) A
) B
GROUP BY GROUPING SETS ((RN10), (RN100), ())
ORDER BY 1, 2


SELECT RN10, RN10 / 10, COUNT(*) FROM 
(
	SELECT RN, RN/10 AS RN10, RN/100 AS RN100 FROM 
	(
		SELECT RN = -1 + ROW_NUMBER() OVER (ORDER BY 1/0) FROM master..spt_values
	) A
) B
GROUP BY GROUPING SETS ((RN10), (RN10 / 10), ())
ORDER BY 1, 2

SELECT RN10, SUBSTRING(RN,3,99), COUNT(*) FROM 
(
	SELECT RN, SUBSTRING(RN,2,99) AS RN10 FROM 
	(
		SELECT RN = CAST(-1 + ROW_NUMBER() OVER (ORDER BY 1/0) AS VARCHAR(99)) FROM master..spt_values
	) A
) B
GROUP BY GROUPING SETS ((RN10), (SUBSTRING(RN,3,99)), ())
ORDER BY 1, 2

SELECT RN10, RN10 / 10, COUNT(*) FROM 
(
	SELECT RN, RN/10 AS RN10, RN/100 AS RN100 FROM 
	(
		SELECT RN = -1 + ROW_NUMBER() OVER (ORDER BY 1/0) FROM master..spt_values
	) A
) B
GROUP BY GROUPING SETS ((RN10), (RN10 / 10), ())
ORDER BY 1, 2