I tried the third method today just on a lark for a new SP I created to import data.  The query runs on tables about 35k records long with 8 columns in about 2 seconds.  It did help me identify a problem with our legacy data (originally thought my new code was bad).  Thanks for sharing!