Order by in over clause (ranking functions) should have own settings
For ranking functions, the order by clause should not be formatted the same are the order by in a select.
sample:
Select
[RowNumber] = RowNumber() Over (Order By o.[Order ID]
, o.[Sort Order]
, o.[Entry No])
8
votes
Joel Brown
shared this idea
-
Joel Brown
commented
Actually since I have enabled the table view option on the select clause, I believe when a field definition spills to many lines they should still stack in the second column and not revert back to the first column.
In other words although the order by columns are supposed to be stacked they should still be stacked within the borders of the outer context in this case field definition of the select clause (which sits in it's own column).