We have a script creating a table for a view. The customer wants the 3 columns to be Green, Red, Black, Blue
How do I change them if i can?
___
Script being used:
SELECT WAN_REPORT_PRIMARY,
COUNT(NodeID) AS TotalNodes,
sum(case when Status = '1' then 1 else 0 end) AS NodeUP,
sum(case when Status = '2' then 1 else 0 end) AS NodeDown,
sum(case when (Status != '1' and Status != '2') then 1 else 0 end) AS Unknown
FROM [dbo].[Nodes]
Where
WAN_REPORT_PRIMARY is not NULL
and
WAN_REPORT_PRIMARY != 'none'
group by WAN_REPORT_PRIMARY
order by WAN_REPORT_PRIMARY ASC
_________________________________________
they want these columns to be these colors.
Ideas?
