Top "Outer-apply" questions

Where to use Outer Apply

MASTER TABLE x------x--------------------x | Id | Name | x------x--------------------x | 1 | A | | 2 | B | | 3 | C | x------x--------------------x DETAILS TABLE x------x--------------------x-------x | Id | PERIOD | QTY | x------x--------------------x-------x | 1 | 2014-01-13 | 10 | | 1 | 2014-01…

sql-server sql-server-2008 left-join outer-apply

Entity Framework and CROSS/OUTER APPLY

I want to create some test cases for Entity Framework queries that surely generate SQL commands that contain CROSS APPLY …

sql sql-server entity-framework cross-apply outer-apply

Is there any alternative for OUTER APPLY in Oracle?

In the following example, I pass tbA.ID to tbC query. In this case, I used OUTER APPLY operator of …

sql-server oracle outer-apply