
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2016 05:50 PM
The report design interface SQL parser seems incapable of handling correlated subqueries or RANK ( ) OVER ( [ PARTITION BY partition_by_column ] ORDER BY order_by_column [ASC|DESC] ) = 1 syntax to allow the retrieval of the top row in a related table for each row in the main query. Shouldn't these both work here? Currently all I get is unexpected token reports for what is perfectly valid T-SQL.
Labels:
- Labels:
-
General Discussion
0 REPLIES 0
