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!

  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