Multiple Ring Buffer with SQL Server

MultipleRingBufferSS.sql

--simple list of values to generate buffers around
DECLARE @buffer_distances TABLE (dist int);
INSERT @buffer_distances(dist) VALUES (1), (2), (3);

SELECT 
	p.STATE_NAME, p.CITY_NAME, b.dist, p.Shape.STBuffer(b.dist) AS Poly 
FROM 
	CITIES p
CROSS JOIN 
	@buffer_distances b
WHERE
	p.STATE_NAME = 'Alaska'
ORDER BY 
	p.CITY_NAME, b.dist;
  
--using CTE to generate a range table with the start and the end values and the step
WITH buffer_distances AS
   (SELECT 5 AS dist
    UNION ALL
    SELECT dist + 5 AS dist
    FROM buffer_distances
    WHERE buffer_distances.dist < 20)

SELECT 
	p.STATE_NAME, p.CITY_NAME, b.dist, p.Shape.STBuffer(b.dist) AS Poly 
FROM 
	CITIES p
CROSS JOIN 
	buffer_distances b
WHERE
	p.STATE_NAME = 'Alaska'
ORDER BY 
	p.CITY_NAME, b.dist;