Automatically have stored procedure output results to file?

• doiq316

  SSC Rookie

  Points: 37

  More actions

  July 15, 2009 at 9:38 am

  #223596

  Hi Everyone,

  I am having a little problem with something and I was wondering if anyone here would have any suggestions as to how to go about doing this. What I am trying to do is have a simple stored procedure that is just selecting certain values from a table automatically output the results as a .rpt file.

  The reason I ask for this is because I want to take that .rpt file and analyze it further with excel. I want to setup a procedure that will automatically have those .rpt files available to me after each run instead of having to manually go in and ask for the results to file.

  Is there any simple way to go about doing this? Thank you in advance for any help I might receive

  Sincerely,

  Jeff Bliss

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738773

  More actions

  July 15, 2009 at 10:14 am

  #1025208

  Do you mean when you run a query from SSMS? Remember that SQL Server is a server, it doesn't typically interact with a client desktop.

  You need a client program to write the file. SSMS or whatever client is calling the SP.

  SQLCMD will write results to a file if you include an OUTPUT file.