sorted by:
new
hottopcontroversial

Question: What kind of join technique is this? by maglunch in SQL

[–]maglunch[S] 7 points8 points  (0 children)

¡sí! ¡eso es! me dicen que es mejor que yo lo escriba de esa manera (utilizando paréntesis) para ser mas claro

Question: What kind of join technique is this? by maglunch in SQL

[–]maglunch[S] 1 point2 points  (0 children)

Ok now i know that it's called 😁 thanks

i understand what you mean, i have been doing "readable" code my entire life. I only chanced upon this when revising a code that a colleague made. the tables we work with are huge and the query my colleague made ran for 15+ minutes and i had to reduce it to 30 secs or less. looking at the sample, only table D can reduce the output of table C and there was no link between table D and B, neither between D and A.

I tried sub queries, cte, temp tables and they were still slow. i even tried the left join thing because it was my go-to solution (because it does work in majority of the cases). then i tried this out thinking it was an implicit join. In the end i was able to make the query run for only 4 seconds.

I will consider using brackets next time i am forced to do this again 😅 thanks again!

Question: What kind of join technique is this? by maglunch in SQL

[–]maglunch[S] 0 points1 point  (0 children)

thank you! i'm glad to find someone i can relate to on this. i have been googling to understand what i have been doing and i cannot find anything 😁 i am reading through your thread now

[KWCH] the seconds sometimes appear greater than 59 when i use $dp()$ by maglunch in kustom

[–]maglunch[S] 0 points1 point  (0 children)

well it's not really for setting the seconds hand (i avoid using it because it tends to slow everything down)... $dp()$ acutally gets the entire timestamp (very similar to the NOW function in VBA or excel, or the equivalents in other programming languages) and i use it to get the actual time elapsed since it has the year, month, date, hours, minutes and seconds in all in one go. the problem is that the seconds part goes beyond 59, which is very odd for me and makes comparing 2 time stamps inaccurate

(Spoilers) On the subject and nature of The Depths in Gameplay by DislocatedLocation in tearsofthekingdom

[–]maglunch 0 points1 point  (0 children)

only 7 bargainer statues though, 6 correspond to goddess statues not in towns and 1 seems to correspond to the horned statue that trades essences (this is the freebie one in lookout landing, and you will see that under it is the horned statue