O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

OUTER APPLY

OUTER APPLY returns from the outer table both rows that produce a result set and rows that do not. Rows that do not produce a result set from the table-valued function return NULL values in the columns produced by the table-valued function.

The following example is similar to the query in Listing 45.45 but replaces CROSS APPLY with the OUTER APPLY clause:

SELECT P.PRoductID, p.Name, s.salesOrderID, s.ORderQtyFROM Production.Product POuter APPLY dbo.fn_GetTopSales(p.ProductID, 3) AS sWHERE p.ProductID BETWEEN 820 AND 823ORDER BY p.ProductID, s.OrderQty DESCGO/* outputPRoductID Name                           salesOrderID ORderQty--------- ----------------------------- ------------ --------      820 HL Road ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required