September 21, 2015 at 10:38 pm
Comments posted to this topic are about the item LEADing Rows
September 21, 2015 at 11:51 pm
This was removed by the editor as SPAM
September 22, 2015 at 12:49 am
Stewart "Arturius" Campbell (9/21/2015)
Nice question, thanks SteveLead and Lag are really handy operators, especially for trend analysis on relational data...
+1
Thanks for sharing Steve.
September 22, 2015 at 12:52 am
Stewart "Arturius" Campbell (9/21/2015)
Nice question, thanks SteveLead and Lag are really handy operators, especially for trend analysis on relational data...
+1.
Easy point. 🙂 Thanks for sharing.
September 22, 2015 at 1:18 am
Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 22, 2015 at 4:47 am
Wow - got one right that Koen got wrong!
September 22, 2015 at 5:31 am
Koen Verbeeck (9/22/2015)
Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!
We all make mistakes, especially when not caffeinated enough.
September 22, 2015 at 5:38 am
paul s-306273 (9/22/2015)
Wow - got one right that Koen got wrong!
I was correct in my head. I only selected the wrong answer 😀 😛 😎
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 22, 2015 at 6:07 am
Koen Verbeeck (9/22/2015)
Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!
LAG and LEAD always trip me up, because I forget what is LAGging and what is LEADing.
(Really, no pun about a LEADing question yet? I'm slightly disappointed.) 😛
September 22, 2015 at 6:11 am
sknox (9/22/2015)
Koen Verbeeck (9/22/2015)
Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!LAG and LEAD always trip me up, because I forget what is LAGging and what is LEADing.
(Really, no pun about a LEADing question yet? I'm slightly disappointed.) 😛
Sorry, I'm lagging behind on replying on the QoTD topics.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 22, 2015 at 6:18 am
paul s-306273 (9/22/2015)
Wow - got one right that Koen got wrong!
Miracles do happen 😀 🙂 😉
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
September 22, 2015 at 6:20 am
sknox (9/22/2015)
Koen Verbeeck (9/22/2015)
Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!LAG and LEAD always trip me up, because I forget what is LAGging and what is LEADing.
Now I will never confuse between them again 😉
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
September 22, 2015 at 7:21 am
Thanks for the question. Of course I can't use these because we are still on 2008.
September 22, 2015 at 7:34 am
Iwas Bornready (9/22/2015)
Thanks for the question. Of course I can't use these because we are still on 2008.
My condolences
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 22, 2015 at 10:15 am
sknox (9/22/2015)
Koen Verbeeck (9/22/2015)
Even though I know what LEAD does, I still got it wrong because for some reason I was thinking from "right to left". Moar caffeine!LAG and LEAD always trip me up, because I forget what is LAGging and what is LEADing.
(Really, no pun about a LEADing question yet? I'm slightly disappointed.) 😛
I agree. I tend to think of LAG as my row is lagging what I'm looking at ahead, but it's the reverse.
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply