Query Result in Mail

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  December 30, 2011 at 11:42 am

  #1427091

  SQLRNNR (12/30/2011)

  ---

  Nah - you can delimit the results in the mailed file using

  @query_result_separator = ','

  That said, you can replace the separator value with a |, tab, or something else if you deem it necessary.

  Cool! I did not know that - thanks!!!

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  December 30, 2011 at 11:50 am

  #1427093

  MyDoggieJessie (12/30/2011)

  ---

  SQLRNNR (12/30/2011)

  ---

  Nah - you can delimit the results in the mailed file using

  @query_result_separator = ','

  That said, you can replace the separator value with a |, tab, or something else if you deem it necessary.

  Cool! I did not know that - thanks!!!

  You're welcome.

  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