WITH TIES clause requires an ORDER BY clause.
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

WITH TIES clause requires an ORDER BY clause.

The query does not conform to SQL syntax, because it uses the WITH TIES clause without an attendant ORDER BY clause. Either remove the WITH TIES clause or add an ORDER BY clause.

Show:
© 2016 Microsoft