Post reply

Multi Line output column

  • December 1, 2011 at 8:50 pm

    #248937

    Hi ,

    I have a requirement to show an output with new line breaks in one of the output column. This is not possible in sql server 2008 Grid output. But i got the output when i set the result as text.

    Now I would like to know whether i can extract this result, with the same format with new line, and save it to a text or .csv file ( by any method,dts or ssis).

    Any help would be really appreciable.

    Thanks in advance

    Jeyis

  • December 1, 2011 at 9:37 pm

    #1415680

    Can you provide an example of what the output should look like?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 2, 2011 at 12:11 am

    #1415720

    jeyis (12/1/2011)

    Hi ,

    I have a requirement to show an output with new line breaks in one of the output column. This is not possible in sql server 2008 Grid output. But i got the output when i set the result as text.

    Now I would like to know whether i can extract this result, with the same format with new line, and save it to a text or .csv file ( by any method,dts or ssis).

    Any help would be really appreciable.

    Thanks in advance

    Jeyis

    SSMS result grid is not designed for it. Line Breaks will be visible if you pull data in front end tools (data grid, reports etc.).

  • December 2, 2011 at 12:28 am

    #1415723

    Hi ,

    It worked when i tried to export to excel. though.csv didn work. excel understand char(10) 🙂

    Thanks

    Jeyis

Viewing 4 posts - 1 through 3 (of 3 total)

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