Started the day off with a little challenge that I need help with. I have data in Table "A" database "Production". I would like to do a Select * from A where ID = '5' then I want to insert the results
into database "Test" table "A".
Is this possible since they tables are in different db's? If so, how can I achieve this?