Just FYI guys - I meant - the stand shouldn't be controversial - because loving your country is normal and appropriate - particularly when you  live in a country that...

Thanks for taking a surprisingly controversial stand... Had a great day discussing the value of our country and system with neighbors.

Brian - thank you for all that info - that is excellent!  I appreciate your time. In this case, it was me not doing my due-diligence. But, your information will...

P.S. - If there is a way to delete a post let me know and I will. Thanks.

Sorry - OK - I guess it was just concatenating the passed in values and the code could still execute with random characters as the varchar(15).

Well, distinct does work - but you are right - hopefully SQL can figure out silliness and make it run like the wind 🙂

In fact, it looks like DISTINCT has a much higher cost than GROUP BY generally. https://sqlperformance.com/2017/01/t-sql-queries/surprises-assumptions-group-by-distinct

I am skeptical that putting a query in an iif in the select...

Thank you both. Both work fine - but is distinct better than group in performance? Also, I thought running a query in the select portion caused multiple queries for each...

Thanks. I have never used LEAD().  Looking into it now. For simplicity of the question, I do have other actions recorded like Close, Ended & Back but all of them...