Faheem,
Did you look at BCP - depending on the size of your tables this might be a faster way of doiing the job.
Use BCP to download both tabels to flatfiles from their original databases. Create a new table and load both flatfiles into it using BCP again.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.