Make Chart (Spatial results) from SQL Query

--To Draw a line string

----------------------------

SELECT geometry::STGeomFromText(

'LINESTRING(0 0,1 1)', 0 );

--To Draw Polygons

-----------------------------

SELECT geometry::STGeomFromText(

'POLYGON((0 0,0 1,1 1,1 0,0 0))',

0 );

SELECT geometry::STGeomFromText(

'MULTIPOLYGON(

((0 0,0 1,1 1,1 0,0 0)),

((2 0,2 1,3 1,3 0,2 0)))', 0 );

--Fetch Data from Table and Form chart

--------------------------------------------------

--Create Table

CREATE TABLE [dbo].[Sales](

[FY] [int] NOT NULL,

[Sales] [int] NOT NULL

) ON [PRIMARY]

--Form chart from Results of table

DECLARE @WKT AS VARCHAR(8000);

SET @WKT =

  STUFF(

    (SELECT ',' + CAST( FY AS CHAR(4) ) + ' ' + CAST( Sales AS VARCHAR(30) )

    FROM Sales

    ORDER BY FY

    FOR XML PATH('')), 1, 1, '');

Select @WKT

SELECT geometry::STGeomFromText( 'LINESTRING(' + @WKT + ')', 0 );

--Form Chart with some manipulations in table Result

DECLARE @WKT AS VARCHAR(8000);

SET @WKT =

  STUFF(

    (SELECT ',((' +

      CAST( FY - 0.3 AS VARCHAR(30) ) + ' 0,' +

      CAST( FY - 0.3 AS VARCHAR(30) ) + ' ' +

      CAST( Sales AS VARCHAR(30) ) + ',' +

      CAST( FY + 0.3 AS VARCHAR(30) ) + ' ' +

      CAST( Sales AS VARCHAR(30) ) + ',' +

      CAST( FY + 0.3 AS VARCHAR(30) ) + ' 0,' +

      CAST( FY - 0.3 AS VARCHAR(30) ) + ' 0))'

    FROM Sales

    ORDER BY FY

    FOR XML PATH('')), 1, 1, '');

SELECT geometry::STGeomFromText( 'MULTIPOLYGON(' + @WKT + ')', 0 );

Ref : http://sqlmag.com/t-sql/generating-charts-and-drawings-sql-server-management-studio