Resolved! OLEDB Query Syntax error
I just used a query for SELECT [first_name], [last_name], RANK() OVER ( PARTITION BY [department_id] ORDER BY [salary]) [salary_rank] FROM [employees$] - but when i run this query using OLEDB VBO- i get this error - ": Syntax error (missing operator...