As I said before, the script in questions works fine in 2000 and 2005 as well.

Without the INSERT, if you only SELECT it doesn't. The SELECT with different datatypes, does not do an implicit conversion.