• Bhuvnesh (11/21/2012)


    Jason-299789 (11/21/2012)


    Thanks Eugene, it just looks odd to my eyes.

    you can test it with actual execution plan . that will give you exact picture what/where/why any object is making difference (if any 😀 😉 )

    Its not exactly practical, as the DB is a 2 TB DW, and requires a restore after each run as its based in an offsite server in order to tune the ETL process.

    It just struck me as odd that the Target table wasnt in the FROM and the Source in the join, basically it looked wierd, as I've always coded updates as per my first query.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices