Well, it's 2025 and this thread still continues...   🙂

I didn't use a stored procedure but a reasonably complex block of code someone else created.   This used temp tables, memory tables ...