Loading

Error "The ORDER BY clause is invalid in views Error Code: 2F0F5E42" Occurs When Using ORDER BY in Custom SQL with MS SQL Server or Azure SQL Data Source

Data pubblicazione: Jan 24, 2025
Descrizione

Issue

When using an ORDER BY clause in Custom SQL while communicating with MS SQL Server or Azure SQL database, the following error occurs:

 

Error Code: 2F0F5E42

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]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.

 

Example SQL:

 
SELECT 
 [Address].[AddressID]
FROM
 [SalesLT].[Address]
ORDER BY
 [Address].[AddressID]

 

Cause

This is a limitation of Microsoft SQL.

 

Risoluzione

Option 1

Use "TOP" in the Custom SQL statement for the ORDER BY clause, following the limitations of Microsoft SQL (Transact-SQL).

 

Example SQL:
=====
SELECT TOP 2147483647
 [Address].[AddressID]
FROM
 [SalesLT].[Address]
ORDER BY
 [Address].[AddressID]
=====
Note: 2147483647 is not a fixed value, you can replace it to any value you want.

 

Option 2

Remove ORDER BY clause from the Custom SQL statement and try to sort data in the Tableau application if needed.

 
 

Numero articolo Knowledge

001496791

 
Caricamento
Salesforce Help | Article