Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 script to retrieve data from DB & store in DB #2

Author  Topic 

sagarthatte
Starting Member

1 Post

Posted - 2013-02-07 : 17:10:03
Hello Guys,

I am looking to do something like this.
I want to construct queries in such a way, that I query a particular table/set of tables in a particular database, and then I store/insert values obtained from the querying into a table in a separate database.

The 2 databases in question are on the same DB Server.

I have seen some probable solutions, but they deal with copying entire database tables, etc.

I am particularly looking to construct SQL script to do this.

Thanking in advance.

Sagar

Sagar T
   

- Advertisement -