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 |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2013-10-30 : 13:34:15
|
| Hi,Would like to copy results of the excellent www.brentozar.com/blitz/ script into a tbl for reporting(SSRS). Problem is I don't know the data types, and due to nested queries, cannot copy into table definition created by sql. Is there a method I could use to insert the results into a table without creating the tbl first and correct schema?<this does not work for example>SELECT * INTO TableA FROM (EXEC [dbo].[sp_Blitz])Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Insert results into tbl from stored proc