Unexpected Result in sp_send_dbmail file attachment

• jlazanowski 58918

  Newbie

  Points: 3

  More actions

  September 17, 2009 at 8:31 am

  #73898

  Hello all,

  I'm encountering a strange issue when attaching a file to sp_send_dbmail, the query runs and mail is delivered correctly, however every other line has a 0 result.

  Example:

  Row 1: Data, Data, Data, Data, Data...

  Row 2: 0

  Row 3: Data, Data, Data, Data, Data...

  Row 4: 0

  .....

  My Query

  EXEC msdb.dbo.sp_send_dbmail

  @Profile_Name = 'OrderMailer',

  @recipients = 'a@b.com',

  @subject = 'Invoices',

  @execute_query_database = 'MyDB',

  @query = @querystring,

  @query_result_separator = ',',

  @query_attachment_filename = 'abc.csv',

  @attach_query_result_as_file = 1,

  @exclude_query_output = 1,

  @query_result_header = 0

  set @queryString =

  ' SET NOCOUNT ON;

  select a.InvoiceID, a.SalesID, PurchaseOrder, ....

  the @queryString param will run in QA with correct results.

  Anyone have any ideas?