Home Forums SQL Server 2008 SQL Server 2008 - General How can i create pipe delimited txt file from sql query results RE: How can i create pipe delimited txt file from sql query results

  • April 29, 2012 at 12:28 pm

    #1480953

    tswathi21 (4/29/2012)

    Hi Lowel,

    Thanks for ur quick response ..can i do that in master database because i'm a tester i don't know ..can i do that or not..

    Here is my database details..can you answer accordingly..

    My db name:Max_Test

    My table name: #temp.

    I need these columns from that table are offer_id,reservation_num,personal_id,acct_nbr_he.

    PLs reply TIA.

    You want that with or without column headers?

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