ZZartin (12/10/2015)

---

Have you tried it? If it's faster you can always take that to whoever...

Jason A. Long (12/10/2015)

---

sql84 (12/10/2015)

---

I have table with about 400 columns and 4 million rows.

the only purpose of this table to be used by a reporting tool. this table is...

I would if I could but the requirement is to get all the columns.

Awesome.. Thanks!

'Lookup' didn't work as I couldn't figure out how to use parameters in 'lookup'. but I was able to get the result by using 'Merge Join' and 'Conditional Split' 🙂

let's say there are 30 tables in server2 like TableB and 30 tables in server1 like TableC.

let me map it.

server2-------------server1

TableB--------------TableC-----same columns

TableD--------------TableE----same columns

TableF--------------TableG----samecolumn

say there is one table in server 1...

thanks for the response Phil, I have added some more details in the original post. unfortunately I wont be able to achieve this task with a simple join. and if...

Steve, i was just editing my post. Linked server are too slow for this task as we are dealing with a huge table in Oracle side. and yes i was...

thank you for the response steve, but i won't be able to do join since the tables are in different servers. sorry should ve mentioned it. i have edited my...

thank you both for your input. i agree with ya'll, it is a weird table design. thing is this a derived table from 6 different tables. we could have done...

Thank you this is what i was looking for:-)

thank you for the reply. may be i am a newbie which is why i couldnt get your query to work\. i tried to run it but it kept on...

thank you sean, it worked.

sorry mark let me correct myself your query works jus fine and yes indeed it is a remarkable job for the information that I have provided. since you have already...

thank you for your effort but I get an error when I run the query

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value ' Enrollments'...