I am trying to insert into temp table with a `insert into....select`. 
my current statement looks like the following:

```
insert into ods.account
(
  AccountNumber,
  AccountName,
  AccountCreated,
  AccountEnded,
  PayoffDate
)
select
  AccountNumber
  , AccountName
  , AccountCreated
  , AccountEnded
  , PayoffDate 
from dbo.InsuranceAccount

```

I want to be able to put this information into a temp table if possible I would like to insert into temp table at the top of my query in SQL Server.