Script Temporary Table Declaration from Query
Context menu item to take the current query under the cursor and script out an appropriate DECLARE @table or CREATE TABLE #table to match the names and types output from the query.
Keith Roe commented
This would be extremely helpful. Right now I have to bounce back and forth from my select to the temp variable to get data types and field names. It can take a very long time to put all of this together. This would be a HUGE timesaver.
This is an excellent suggestion. Supprised it has not been implemented yet.