1. User has tried to add multiple statements in Optimizer for rewrite of query:
Declare...
Select ....
2. Optimizer does not support undefined table type variables.
1. SQL Optimizer for SQL Server supports only one statement at time, so multiple statements are not allowed in SQL optimizer to optimize query. Modify the script so that only one statement is entered.
2. To execute @table type variable that requires a separate Declare statement, user needs to create a temporary table by using the “Temp Tables" option.
Refer to attached document for detailed steps.
