HI,
I have requirement like
i have to define color codes depends upon data in every column
the date is like FROM FIRST TABLE
DIFFERENT COLOR CRITERIA FOR DIFFERENT SID VALUES
TABLE1 HAVE SID AND RESPECTIVE VALUES COLUMN
SID JE_VALUE
100 50
100 75
100 99
101 20
101 45
101 75
QUERY RESULT LIKE BELOW
SID JE_VALUE JE_COLOR
100 50 GREEN
100 75 AMBER
100 99 RED
101 20 GREEN
101 45 AMBER
101 75 RED
my color criteria HAVE TO DEFINE IN SECOND TABLE
I HAVE TO CRETE TABLE2 LIKE THIS CRITERIA
FOR SID= 100 THEN
<50 - GREEN
>50 AND <75 - AMBER
>=99 - RED
FOR SID= 101 THEN
<25 - GREEN
>50 AND <25 - AMBER
>=75 - RED
TABLE2
SID GREEN RED AMBER
100 50 99
101 25 75
GREEN AND RED COLOR ARE SINGLE CRITERIA ONLY.BUT AMBER HAVE 2 CRITERIAS
HOW TO DEFINE AMBER COLOR DATA IN SINGLE COLUMN IN TABLE2
HOW TO WRITE AMBER VALUE CRITERIA IN QUERY FROM TABLE2 DYNAMICALLY WITH TWO COLOR CRITERIS IN CASE STATEMENT
IF I HAVE TO WRITE CASE IN SELECT HOW TO WRITE FOR AMBER COLOR CRITIRIA .
SELECT SID,JE_VALUE,
CASE WHEN SID='100' AND JE_VALUE <TABLE2.GREEN THEN 'GREEN'
WHEN SID='100' AND JE_VALUE <TABLE2.RED THEN 'RED' ELSE NULL
END JE_COLOR