Automate Creating CTE Query from Access Stacked Query
If you have a query that depends on another query (stacked query), it can be tedious to recognize if it is a good candidate to be converted into a single SQL statement as a "derived table" or a SQL Server CTE (common table expression). This quick video demonstrates some tools I've developed to streamline the conversion process.
Tools used in this demonstration:
MS Access O365
Query Explorer - add-in
Merge Depend Query as Derived Table/CTE - add-in
Notepad++ (for visualizing SQL)
SQL Pretty Formatter - AutoHotkey macro
SQL Converter (https://accessusergroups.org/sql-conv...)
SSMS (to show the converted SQL works)
Please give a thumbs up if you liked this video.