Follow these guidelines when using UNION with other Transact-SQL statements:
The INTO clause can be used only in the first query; if it appears anywhere else, you get an error message. Also, remember that if the select into/bulkcopy option is not set, SELECT INTO can be used only to create temporary tables.