Post reply

Anyone know t/sql for displaying results in TEXT

  • June 16, 2004 at 3:18 am

    #108139

    I have to manually change the results to display in text through 'Query' on the menu bar and then change back to grid, for certain daily scripts I run.

    Does anyone know any t/sql I can write in front of the query to display text and after to revert back to grid. I have checked out all the SET commands and cannot find one that is applicable.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • June 16, 2004 at 5:11 am

    #510612

    I don't think that TSQL will do it because that just controls the behavior of the data and server not the QA tool However, why not open 2(two) different QA instances with one set to Grid the other Text and produce your reports that way?

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 17, 2004 at 4:54 am

    #510788

    Thanks. That is what i am doing. My manager wants to be able to log on to qa every morning and run the job in my absence without having to fluff around.

    Guess he'll have some extra work after all (couple of extra mouse clicks)

    ------------------------------
    The Users are always right - when I'm not wrong!

  • June 17, 2004 at 10:58 am

    #510900

    Why don't you set up a job to call your T-SQL code and schedule it for every morning? will save you work when youare in aswell.

    Lloyd

  • June 17, 2004 at 11:32 am

    #510911

    DTS results to text file on managers desktop?

    Alternatively, xp_SendMail - results delivered to your inbox

  • June 18, 2004 at 6:45 am

    #511008

    Great!,great!

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • June 21, 2004 at 2:22 am

    #511180

    We have not got mauil set up on the server. I think I will go the dts route. That way I can also keep a history of log files if I dynamically name the file by date.

    Thanks for everyone's help.

    ------------------------------
    The Users are always right - when I'm not wrong!

Viewing 7 posts - 1 through 6 (of 6 total)

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