Create Temp table in SQL Server

Example:


select LogID, Severity, Timestamp, Win32ThreadId, Title
into #Start_time
from log(nolock)
where Message like '%ValidateAndActivate%'
and Severity='Start'
and timestamp between '2011-01-29' and '2011-01-30'