I totally agree with the Example. I have scenrio where I am creating Temo table using Select into #temp and later on using same table to insert data using Insert into Select from table.