TSQL的outer apply範例

http://sqlfiddle.com/#!18/d47fe/2


ref:
https://docs.microsoft.com/zh-tw/sql/t-sql/queries/from-transact-sql?view=sql-server-2017

合併查詢結果
http://vito-note.blogspot.com/2013/05/blog-post_134.html

[SQL] APPLY
http://jengting.blogspot.com/2014/03/apply.html

https://www.mssqltips.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/

SQL Server 2005 新功能-APPLY 運算子
https://blog.xuite.net/sunnysoap/r/15570805-SQL+Server+2005+%E6%96%B0%E5%8A%9F%E8%83%BD-APPLY+%E9%81%8B%E7%AE%97%E5%AD%90