SQL Server Performance

Problem with migrating multiple LEFT JOINS from Sybase to SQL Server

Discussion in 'General DBA Questions' started by Marco Salazar, Sep 12, 2012.

  1. Marco Salazar New Member

    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??

Share This Page