SQL script refactoring of OUTER APPLY

Job ID: 35274664

Budget: $30 – $250 USD

Currently we're using Azure SQL database + Azure Data Factory, where we have a complex script for selecting data into a table. The script is around 350 rows, and it is using OUTER APPLY. Now we are migrating to Databricks, which doesn't support OUTER APPLY function.
Thus we need to refactor SQL script from the use of OUTER APPLY to LEFT JOIN.
Related categories: SQL Microsoft SQL Server