I am very glad this worked for you. I think that we have not promoted the use of CTE queries enough. I always thought that the CTE queries were only for creating recursive queries, but that is only a minor reason to use them.
timshuwy
(Tim Shoemaker)
7
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Dashboard without filters runs fast, specifying a filter slows it considerably | 3 | 476 | January 9, 2020 | |
| BAQ Filtering By InvcHead.InvoiceDate | 14 | 2215 | January 20, 2020 | |
| BAQ Speed Improvement TIP | 5 | 2443 | April 7, 2020 | |
| Strange, Poor BAQ Performance? | 26 | 3627 | August 4, 2021 | |
| Speed up baq | 6 | 1020 | August 21, 2023 |