Is it possible to move rows from Table1 in Database1 to Table2 in Database2?

[Mark Nelson]

Is it possible to move rows from Table1 in Database1 to Table2 in Database2?

Say, I have Database1 containg Table1:

ID ¦ Cars
---------------
1 BMW
2 Mercedes
3 Toyota
1 Opel
etc....

And Database2 containg Table2 (that is empty just at the moment):
ID ¦ Cars
---------------
no data added yet...

How can I copy say everything from Table1 that has ID=1 (the parameter I send in with the stored procedure at execution), and insert this in Table 2?
This would be, I insert the row with the BMW thingy and the row with the Opel thingy as 2 new rows in table 2.
Note that the two tables are located in 2 different databases.

I am using SQL Server 7 and am trying to implement this in a stored procedure.

Thanks for all help!!

Mark Nelson

[Mark Nelson]

I've solved this....