<p>I want to do something like </p>

<pre><code>insert into my table (select * from anothertable where id &lt; 5)
</code></pre>

<p>What is the correct MSSQL syntax?</p>

<p>Thanks!</p>

Is this what you're looking for?
```
```
INSERT INTO MyTable
SELECT * FROM AnotherTable
WHERE AnotherTable.ID < 5
```
```