Multi-Rectangle \ Spiral [T-SQL]

I wrote a script which draws multiple rectangle-inside-rectangle in T-SQL. The number of rectangles to be drawn can be set ... to a certain extent ;)

A change of a parameter at the end of the script produces a spiral.

-- Multi-Rectangle \ Spiral -- by Oren Hadar, 2009 DECLARE @total INT DECLARE @count INT DECLARE @horiz INT DECLARE @vert INT DECLARE @max_vert INT DECLARE @h_draw varchar(128) DECLARE @v_draw varchar(128) SET @total = 7 -- @total sets to number of rectangles SET @count = @total SET @max_vert = @total * 3 SET @horiz = @total*6-3 SET @vert = @total * 3 - 1 SET @h_draw = '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' SET @v_draw = '+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +' WHILE @vert > -@total * 3 - 3 BEGIN PRINT LEFT(@v_draw, @max_vert-ABS(@vert)) + SUBSTRING(@h_draw, 1, ABS(@horiz)) + RIGHT(@v_draw, @max_vert-ABS(@vert)) PRINT LEFT(@v_draw, @max_vert-ABS(@vert)) + REPLACE(SUBSTRING(@h_draw, 1, ABS(@horiz)), '+', ' ') + RIGHT(@v_draw, @max_vert-ABS(@vert)) SELECT @horiz = @horiz - 6 SELECT @vert = @vert - 3 SELECT @count = @count-1 IF @count=0 BEGIN -- In the next line, change the '-2' to '+1' to get a spiral! SELECT @horiz=@horiz-2 SELECT @vert=@vert-2 END END