Cayetano Gonçalves
Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Scholar
Impact
~703 people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Feb
10
comment Unexpected extremely long query time (~5 minutes using nested WHEN-INs)
I really appreciate all the help you have added to your answer. Thank you again, time to brush up it seems.
Feb
10
comment Unexpected extremely long query time (~5 minutes using nested WHEN-INs)
0.0010 seconds for my test run, my employee account has 761 reports that should appear. I am totally blown away, and I am going to pull out my text books it seems.
Feb
10
awarded  Scholar
Feb
10
accepted Unexpected extremely long query time (~5 minutes using nested WHEN-INs)
Feb
10
comment Unexpected extremely long query time (~5 minutes using nested WHEN-INs)
WHOA! The first suggestion you had using USING was nearly instant. Sir, if I could give you a million upvotes. I would. Now, I have to go study what USING even does.
Feb
10
awarded  Supporter
Feb
10
awarded  Student
Feb
10
asked Unexpected extremely long query time (~5 minutes using nested WHEN-INs)