July 12, 2018 at 8:33 pm
Comments posted to this topic are about the item Stats_ID
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 13, 2018 at 12:49 pm
Steve, it does not work for me. I got this one wrong; however, when I ran it in SSMS and checked, I got clearly 1.
Are you sure your answer is correct?
July 15, 2018 at 10:27 pm
Interesting,thanks Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 16, 2018 at 8:05 am
Revenant - Friday, July 13, 2018 12:49 PMSteve, it does not work for me. I got this one wrong; however, when I ran it in SSMS and checked, I got clearly 1.Are you sure your answer is correct?
Are you checking for the PK or the clustered index? For the CX, it's one. In the question, the clustered index is on OrderDate, but the PK is OrderKey.
I get
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 16, 2018 at 8:35 am
Nice Question Steve,
Got it wrong I didn't read the question properly,
DOH!!
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
July 16, 2018 at 9:59 am
Steve Jones - SSC Editor - Monday, July 16, 2018 8:05 AMRevenant - Friday, July 13, 2018 12:49 PMSteve, it does not work for me. I got this one wrong; however, when I ran it in SSMS and checked, I got clearly 1.Are you sure your answer is correct?
Are you checking for the PK or the clustered index? For the CX, it's one. In the question, the clustered index is on OrderDate, but the PK is OrderKey.
I get
Ah-hah! Thanks, Steve!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply