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: 90256 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: 14047 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: 1003873 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: 14047 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: 1003873 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: 246712 More actions · Answer 6

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

SQLisAwe5oMe SSChampion Points: 14047 More actions · Answer 7

Thank you Jeff, this is helpful.

Regards,
SQLisAwe5oMe.

Jeff Moden SSC Guru Points: 1003873 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: 1003873 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)