[en] Varicent Incentive Compensation Management Documentation

[en] 00192220, 00192225 — Import error related to ORDER BY clause

[en] Fixed: Imports using ORDER BY clause in subqueries result in an error. The error message is "The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified. Incorrect syntax near the keyword 'order'."

[en] Reproduction steps

  • [en] Use ORDER BY clause in a subquery.

[en] Result: error occurs.