SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 script to retrieve data from DB & store in DB #2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sagarthatte
Starting Member

USA
1 Posts

Posted - 02/07/2013 :  17:10:03  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000