Post reply

Any option to get rid of "rows affected" line ?

  • October 28, 2008 at 4:30 am

    #126564

    Hi ,

    I need to get the query results to csv file. But on getting the results there, along with the data I also get lines saying "6 rows affected" or "1 row affected". Is there any option to get rid of this line? Moreover I am running the query through a job & getting the results into csv file. Please suggest a method ASAP.

    Thanks

    Have a nice day !!!

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • October 28, 2008 at 4:38 am

    #890488

    Hi,

    I have resolved it myself... 🙂

    Thanks

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • October 28, 2008 at 4:46 am

    #890489

    Hi,

    Well done for solving it, but could you post your solution too please. It'll provide a reference for anyone else with the same query.

    Thanks, 😀


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • October 28, 2008 at 4:49 am

    #890491

    start your query with:

    SET NOCOUNT ON

    Wilfred
    The best things in life are the simple things

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

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