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.
14090 SW TENNESSEE LN