Post reply

dynamically formatting result set text?

  • February 25, 2008 at 8:57 am

    #74049

    Is it possible to dynamically format the text (font color, specifically) of a result set based on certain conditions?

    I'm running a script several times a day that gives status updates on my system and I wanted to see if I could format that result text to be red if there is some specified criteria is met.

    Thanks in advance

  • February 25, 2008 at 9:06 am

    #781604

    No you cannot dynamically format result set text in Query Analyzer or any other direct SQL tool that I am aware of. If this is that important to you and you are using SQL 2000 I would use Reporting Services and run the scripts there as the report data source(s) and then use Reporting Service to format the results.

    If you don't have 2000 then you would need to write some kind of UI that runs the scripts and does the formatting. Or I think you could use a Job that mails you the results in HTML format and you could embed HTML tags in your results.

    Basically SQL is a data language and does not do formatting, that's what GUI's are for.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 2 posts - 1 through 1 (of 1 total)

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