How to add background color of row based to existing SP/query

Question

Post reply

How to add background color of row based to existing SP/query

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90304 More actions · Answer 1

Here is a previous discussion that give you some ideas on how to accomplish this task:

https://www.sqlservercentral.com/forums/topic/create-total-record-in-html-email/page/2

https://www.sqlservercentral.com/forums/topic/create-html-email

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 2

Thank you Jeff, this is working as I expected.

Really appreciate taking the time out of your busy life to help out.

Regards,
SQLisAwe5oMe.

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 3

Thank you for the feedback.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 4

Hi Jeff - quick question

I was trying to replace 'Green' color with color code #90EE90....but it's not working.....any idea what I am doing wrong?

(

SELECT td = CONCAT('~bgcolor="'

,CASE mirroring_state_desc

WHEN 'SYNCHRONIZED' THEN 'Green"'

WHEN 'SUSPENDED' THEN 'Yellow"'

WHEN 'DISCONNECTED' THEN 'Red"'

ELSE 'White"'

END,'~',databasename)

(

SELECT td = CONCAT('~bgcolor="'

,CASE mirroring_state_desc

WHEN 'SYNCHRONIZED' THEN '"#90EE90"'

WHEN 'SUSPENDED' THEN 'Yellow"'

WHEN 'DISCONNECTED' THEN 'Red"'

ELSE 'White"'

END,'~',databasename) ,''

Regards,
SQLisAwe5oMe.

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 5

I try to avoid the RGB notation because it makes troubleshooting a whole lot more difficult. If you go to the following link...

https://www.w3schools.com/tags/ref_colornames.asp

... and do a search for the #90EE90 color code, you'll find the name for that RGB color combination. Also continue the search on that site, you'll also find out how to use the RGB notation for colors that are not pre-defined.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Phil Parkin SSC Guru Points: 246979 More actions · Answer 6

Jeff, that's a rather useful link, thanks for posting.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 7

Thank you Jeff, this is helpful.

Regards,
SQLisAwe5oMe.

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 8

Phil Parkin wrote:

Jeff, that's a rather useful link, thanks for posting.

Thanks for the feedback on that, Phil. I LOVE that site. T It also has one of the better beginner SQL tutorials and keeps on getting better as time wears on.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 9

SQLisAwe5oMe wrote:

Thank you Jeff, this is helpful.

You bet... thank you for the feedback. It also has one of the (IMHO) better SQL Tutorials (Not to mention the HTML and other tutorials) for beginners and they keep making improvements.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)