Resolved: Alternative solution
I just wanted to check if my alternative solution is also valid. It produced similar results as the attached solution. Is the 365 attached solution the "most correct" way to do this? If so, why? I know a few of the videos mention optimization, could my code be less efficient on a larger scale/table?
Thanks for reaching out.
Yes, your solution is valid. It depends on some factors like created indexes and the number of records. But for this DB your solution is optimized.
Hope this helps.