Return
-
Title
Cannot optimize query that uses variables of type table. -
Description
A script was entered in Toad Editor and user has tried to optimize using SQL Optimizer. The query includes a join with a table type variable. Optimizer shows an error when user attempting to rewrite the query.
"Invalid SQL statement.
Only one SELECT/INSERT/UPDATE/DELETE/MERGE statement is allowed."
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.