If you want to return the recordset as well as insert the returned rows into another table then you will have to write a batch or script to accomplish this. In SQL Server you could do it like this:
Code:
INSERT INTO tblNew
(col1, col2, col3)
SELECT col1, col2, col3
FROM tblTemp
WHERE ID NOT IN (
SELECT ID FROM tblMain)
GO
SELECT * FROM tblNew
I hope that helps
Regards
Owain Williams