Post reply

Columns (header) and setting something off

  • December 10, 2008 at 1:00 pm

    #202756

    Result of a query run by osql, written to a flat file shows “1> 2> 3> 4> 5> 6> 7> Column_one ... " on the first line. :w00t:

    How to avoid this by:

    1 Show only Column name.

    2 Show nothing at all.

    Thanks in advance.

  • December 10, 2008 at 9:24 pm

    #910810

    Post the OSQL command, please.

    --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)

  • December 11, 2008 at 3:43 pm

    #911378

    Thank you Jeff. Here is the command line:

    osql –Sserver –Uuserid -Ppassword –i inputfile –o outputfile

    Do you suspect a problem in osql?

  • December 11, 2008 at 7:04 pm

    #911412

    Try adding the -n parameter to the OSQL cmd line.

    --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)

  • December 12, 2008 at 4:34 am

    #911552

    Thank you very much Jeff. "-n" resolved the problem.

    Best Regards,

    Sohrab 🙂

  • December 12, 2008 at 8:23 pm

    #911989

    You bet... 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)

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

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