title: joining and inserting into same table
body: <p>I have a query which runs in SQL Server 2000.</p>
  
  <pre><code>INSERT INTO #Student
     select a,b,c
     from ID i
     inner join #student t on i.ID = t.ID
  </code></pre>
  
  <p>But in SQL Server 2008 it doesn't run.. any idea how to get around this?</p>