• mister.magoo (7/31/2013)


    mcummings (7/31/2013)


    adding sorels.fpartno = aritem.fpart cuts it down from 3075 to 1204

    but there's no fitem in sorels

    As I said, WE are guessing - you shouldn't be .

    If you don't understand how those tables are related, you should not be changing anything until you learnt the relationships.

    Sorry to be blunt, but if you are being paid to do this, you should learn not guess.

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events