Viewing 12 posts - 1 through 12 (of 12 total)
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...
July 6, 2021 at 7:26 pm
Thanks for taking a surprisingly controversial stand... Had a great day discussing the value of our country and system with neighbors.
July 5, 2021 at 3:40 am
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...
June 7, 2021 at 5:34 pm
P.S. - If there is a way to delete a post let me know and I will. Thanks.
June 7, 2021 at 5:24 pm
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 🙂
May 6, 2021 at 8:53 pm
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...
May 6, 2021 at 8:30 pm
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...
May 6, 2021 at 8:26 pm
January 19, 2019 at 12:25 am
January 17, 2019 at 8:37 am
January 16, 2019 at 8:35 pm
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...
January 16, 2019 at 3:30 pm