• gary.rumble (11/25/2009)


    Tom Garth (11/25/2009)


    The 2nd SELECT has no ORDER BY clause, and the table variable has no index. How do you know what the last row will contain?

    😛

    The second query returns null so the variable isn't modified from the first query.

    I hope it was a joke (see emoticon)

    :w00t:



    See, understand, learn, try, use efficient
    © Dr.Plch