Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now