Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
View products that this article applies to.
When you run an INSERT ... SELECT statement in Microsoft Analytics Platform System (APS) 2016 or a later version of APS and that statement includes an ORDER BY clause, you receive an error message that resembles the following:
Msg 104381, Level 16, State 1, Line 26
The ORDER BY clause is invalid in views, CREATE TABLE AS SELECT, INSERT SELECT,
inline functions, derived tables, subqueries, and common table expressions,
unless TOP or FOR XML is also specified.
This issue occurs because sort operations aren't valid with the INSERT ... SELECT statement. This is by design.
In earlier versions of APS, no error may have been returned. However, the ORDER BY clause was not honored.
Keywords: kbContentAuto, kbtshoot, kbExpertiseAdvanced, kb, Msg 104381, the order by clause is invalid in views analytics platform system