1/* Get the data into a temp table */
2SELECT * INTO #TempTable
3FROM YourTable
4/* Drop the columns that are not needed */
5ALTER TABLE #TempTable
6DROP COLUMN ColumnToDrop
7/* Get results and drop temp table */
8SELECT * FROM #TempTable
9DROP TABLE #TempTable