Comments (6)

  1. Would you be able to selectively do this to a particular row based on a value within that row? Say you wanted to highlight any row that has a value within it greater than 10,000?

    1. Absolutely. I have done versions of this where at run time it set a style tag for either the TR or TD element to highlight certain values.

  2. Thanks for this post! I had to do something similar and your post provided a great blueprint. Thanks again!

    1. You’re welcome!

  3. Could you please explain why this code does not work in SQL 2000 and what needs to be done to make it work? I am getting below error:
    Msg 156, Level 15, State 1
    Incorrect syntax near the keyword ‘For’.

    1. It would have to be completely rewritten for SQL 2000. SQL 2000 did not have those SQL views or MAX data types.

Leave a Reply to SQLSoldierCancel reply