This is a good example for us to see the usage of GO and temp table. Within one batch, we can't use into to create the same temp table twice. That's why the SQL engine (not sure exact name but kind of) quickly found this syntax error and complained.
Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how