Best way to create a temp table with same columns and type as a permanent table February 3, 2023 by Tarik select top 0 * into #mytemptable from myrealtable