Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-28 : 08:12:47
|
| Beth writes "I have a file that has 100+ sql statements in it that was generated from a query log from our application. I want to run showplan_all on each statement and load the results into an excel file or a database table. Has anybody seen a script like this?" |
|
|
Jay99
468 Posts |
Posted - 2002-03-28 : 08:51:38
|
| Create a table that matches the output of showplan_all and then insert ShowPlanTable (<columnlist>) <select query>.Jay<O> |
 |
|
|
|
|
|
I need a way to load the results of showplan_all into a table or file for many queries