December 27, 2013 at 8:22 am
Hi,
I have to create a chart based on server performance as shown in the attachment.
CREATE TABLE #SSRSChart ( Status VARCHAR(10),ServerName VARCHAR(10),HOUR INT)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',0)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',1)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',2)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',3)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',4)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',5)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',6)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',7)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'SUCCESS', 'Server B',0)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server B',1)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'WARNING', 'Server B',2)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server B',3)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server A',4)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'SUCCESS', 'Server B',5)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'SUCCESS', 'Server B',6)
INSERT INTO #SSRSChart
( Status, ServerName, HOUR )
VALUES ( 'ERROR', 'Server B',7)
SELECT * FROM #SSRSChart ORDER BY 2
DROP TABLE #SSRSChart
Please help.
January 3, 2014 at 10:04 am
Why not just create a report? When I look at your attached picture, it looks like a straight-forward report to me.
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply