Hi chaosgray,
You can use full qualified table names to do this(only if both the databases are of same type (SQL SERVER))
Please try
SELECT INTO
SELECT * INTO
[Database1].[dbo].[CodeProjectTmp1]
FROM [DataBase2].[dbo].[CodeProjectTmp2]
The same logic will workout for
INSERT INTO
along with a
SELECT
statement.
You can also try
OUTPUT clause in SQL server to tweak it
click here for more about OUTPUT clause