 <p>OK for some reason this slipped my mind, im actually doing it in the same SP :)</p> <pre><code>INSERT INTO [tblMyTable]([Field1]) SELECT [DataField] FROM [tblDataTable] </code></pre> <p>very easy :)</p>