In this blog post, you’ll learn more about the Sybase Error Warning detected when optimizing SELECT INTO is treated as an error and the reason for receiving this error
Sybase SQL Error Message
Warning detected when optimizing SELECT INTO is treated as an error
Reason for this Error
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.