Problem with migrating multiple LEFT JOINS from Sybase to SQL Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with migrating multiple LEFT JOINS from Sybase to SQL Server

Hi I’m migrating an SP from Sybase to SQL Server and in some query I have a multiple left outer join (*= operator) table1.a *= table2.a
table1.c *= table3.c
table1.d *= table4.c
table2.e *= table5.e
table2.f *= table6.f
table5.g *= table7.g
table6.h *= table8.h Which I’m trying to modify to SQL conventional LEFT JOIN, however I’m unable to make it work given that the same table is used in several places of the joins… table1 left join with table2
table1 left join with table3
table1 left join with table4
table2 left join with table5
table2 left join with table6
table5 left join with table7
table6 left join with table8 Any ideas??
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |