Ryan,

   That is exaclty what example 3 does.

While I agree with everyone that you should specify the columns when doing an insert, that is NOT a requirement of the insert...

Some relevant points:

1. I always specify columns in my production code.  I wrote this code to further examine what appears to be a bug.

2. If you substitute literal strings the 1st...

Look again, I have 7 columns in example 1, which should insert correctly since the temp table has 8 columns with the identity.  For Example 2, I simply dropped the...