Pivot Results - Database Mail

• kiran 4243

  Mr or Mrs. 500

  Points: 553

  More actions

  November 26, 2014 at 2:58 am

  #397693

  Hi,

  Can you please tell me is it possible to send Pivot query results as automated database email ?

  Thank you.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 26, 2014 at 3:37 am

  #1761031

  Yes, exactly as any other kind of query.

  -- Gianluca Sartori

• kiran 4243

  Mr or Mrs. 500

  Points: 553

  More actions

  November 27, 2014 at 6:51 am

  #1761305

  Hi,

  Thank you very much for your valuable support.

  Can you please provide an example.

  Thank you.

• pietlinden

  SSC Guru

  Points: 63517

  More actions

  November 28, 2014 at 7:20 pm

  #1761492

  Exercise your GoogleFu... There are examples all over the place, especially on the MS website...

  http://msdn.microsoft.com/en-us/library/ms190307.aspx

  See example B.