We help IT Professionals succeed at work.

I am two different database one is call gmg_order_entry and the other is call gmg_claims I would

1030071002
1030071002 asked
on
258 Views
Last Modified: 2012-06-27
I have two different database one is call gmg_order_entry and the other is call gmg_claims both of them have two tables with the same name call zipcodes. However, the gmg_order_entry database zipcodes table is populated and I would like to copy those data to
the gmg_claims table call zipcodes which have the same schema as the gmg_order_entry zipcode tables. I am using  Microsoft SQL Server 2000. Please advice how I may accomplished this.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Awarded 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
insert into zipcodes

dont I need to put on the table name like gmg_claims

Author

Commented:
INSERT INTO gmg_claims.dbo.zipcodes
SELECT * FROM gmg_order_entry.dbo.zipcodes

Work Great Thank u

Author

Commented:
INSERT INTO gmg_claims.dbo.zipcodes
SELECT * FROM gmg_order_entry.dbo.zipcodes
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.