Format of output from a sql query 'To File'

  • I have written some queries to pull data out of some tables.

    As I want the data in character | delimited format I am using the 'to file' option when running the query.

    I have formatted the results as I need them but at the end of the file I always get:

    a blank line

    count of number of records in the file

    a blank line

    I would like to turn the 'statistical count' off as I do not want them?

    Can anyone help

  • add

    SET NOCOUNT ON

    to the top of your t-sql code.

  • Great

    That does it..

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

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