Etract data from 1 table to other table with 2 different database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

my issue is

i have get data from different database on same server
into my datbase ( only selected data not import or export all)
(e.g)
My db name Roaster and table name overtime

other db name HR and table employeesalary

so i have to pick employee salary from HR datbase by employeeno(its also
exist in my Roaster database table )

i want to pass employeeno to Hr datbase from Roaster to extract record
how can i do this ?

thanks

Posted 28-May-12 20:59pm

qasimidl

Add a Solution

Comments

Jim Jos 29-May-12 3:17am

Sir! study about inner joins!!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sivasankari ts · Answer 1 · 2012-05-28T21:17:00

Solution 2

Hope this helps you

XML

<pre lang="sql">

SELECT a.salary  FROM HR .dbo.employeesalary a inner join Roaster .dbo.overtime b  ON a.employeeno=b.employeeno</pre>

Posted 28-May-12 21:17pm

sivasankari ts