Error 995

"Warning detected when optimizing SELECT INTO is treated as an error"

Item	Description
SQLCode	-995L
Constant	SELECT_INTO_WARNING_TREATED_AS_ERROR
SQLState	WP016
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	2662
Severity Code	16

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.