Hi

You need to create Linked servers to access Oracle data from SQL Server.

I did the similar thing. Just copied the table structures and T-SQL objects and there were no issues. But instead of copying it would be better to re-design the sps....

I am going in circles in circles in this thread...:blink:

Hi

Check out the below link

http://www.dotnetvj.com/2009/03/load-text-or-csv-file-data-into-sql.html

Linda hammell (4/6/2009)

---

Just wanted to let you know that after a bit of fighting with it, I was successful in using a UDF to put the data in the format...

Thank you Gail.... 🙂

J-F Bergeron (4/7/2009)

---

Yeah, just check the execution plan on every query you make, and it will say you have "no join predicates" between 2 tables. That's a cross join, and...

When...

Is there any way that we can find out the Cross-Join can happen? with out looking at the data just by lookin at the SQL?

Hi

Sample data is very much required like "what is the input" and "what is the out put" you are looking for. 🙂

Hi

The simple way to do is, Goto the Members section and Sort it based on the No.Of Posts in DESC order then you will come to know where you stand.

Simple terms you can't magic tables in any kind of dynamic queries.

Hi

You want to do this in SQL statement or with the help of T-SQL?

Hi

Could you please provide table structures.

If you want to convert rows into columns then you can try out PIVOT.

Hi

Thank you guys for giving so many valuable links..