A query using inline functions is entered in Optimizer. When attempting to optimize the query the following error occurs:
"Parsing Error: Invalid SQL statement"
WORKAROUND:
Create a View to select from the inline functions, and replace the SQL to reference to the view. Once an optimized alternate is found, manually replace the view back to the inline functions.
STATUS:
Enhancement request ST 41213 has been submitted to Development for consideration in a future release of Quest SQL Optimizer for SQL Server.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center