SQL Select Into

Select the results of a query into a new table

Select * from [OrigView] into [NewTable]