|
DECLARE @C INT=1,@ VARCHAR(MAX)=''
WHILE @C<32
SELECT @+='|.0,0 .x'+iif(@C=14,'|26,0 x',''),
@C+=1
SET @=REPLACE(REPLACE(REPLACE(@+'|-26,0 -26?',
'|','SELECT CAST(''POLYGON((0 0,78 0,78 '),'x','26?UNION ALL '),'?',',0 0))''AS GEOMETRY)')EXEC(@)
(No column name) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 26, 0 26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 0, 0 0.26, 0 0)) |
POLYGON ((0 0, 78 0, 78 -26, 0 -26, 0 0)) |
… |
|