Warning detected when optimizing SELECT INTO is treated as an error

Probable cause 

The SELECT ... INTO #TEMPTABLE statement cannot proceed if a warning is detected while optimizing the query. To fix the problem, test the query by removing the INTO clause, and resolve the reported warning.