title: Tool to export result set from SQL to Insert statements?
body: <p>I would like to export a ad hoc Select query result sets from SQL Server to be exported directly as Insert Statements.</p>
  
  <p>I would love to see a Save As option "Insert.." along with the other current available options (csv, txt) when you right-click in SSMS. I am not exporting from an existing physical table and I have no permissions to create new tables so the options to script physical tables are not an option for me.</p>
  
  <p>I have to script either from temporary tables or from the result set in the query window.</p>
  
  <p>Right now I can export to csv and then import that file into another table but that's time consuming for repetitive work. </p>
  
  <p>The tool has to create proper Inserts and understand the data types when it creates values for NULL values.</p>