Complex x++ to AOT queries using Ranges.

Recently I came to know that we can make some complex queries in the AOT as well by adding the ranges.

For example

SELECT * FROM EmployeePosition

JOIN * FROM PositionDetailTable

WHERE EmployeePosition.ValidFrom <= PositionDetailTable.ValidFrom

&& EmployeePosition.ValidTo <= PositionDetailTable.ValidTo

Attached is the sample AOT query that will produce the same result. you need to download and remove the .doc extension from the file.



Get every new post delivered to your Inbox.

Join 702 other followers

%d bloggers like this: