3 days is definitely ok. It’s helped me get trough the backlog. Look how long it took me to get to this one. 🙂

I chose A and B which just goes to show that you should never take a quiz right after you wake up. “Ascii code 65 means A, peace of cake,...

I think he means this..

Just trimming Steve's code, this produces the "expected result"

with part_cte as (
    select PartId,
      ...

Since 1 mile is 5280 feet and your field is storing the data in feet, just divide your field by 5280.

When you divide 1 by 5280 you get .000189393 with...

It sounded really cool, and I agree that it is a really good idea, though I was surprised you would have time to deal with it.

Was it also part of...

You commented that you thought the intellisense seemed a little buggy, but it looks to me that it's quite clever. After you typed the letter 'c' it showed a list...

I just spent a half hour learning about R just to answer this question. I didn't have a clue before, and probably still won't be using this language. lol
But...

If this is being deprecated, what’s the replacement for this functionality? Or is it one of those “nobody uses it so why keep it” situations?

Good to know, but I think if I need more than 10, I'm gong to pass an array or memory table or pretty much anything else 🙂

Where do the fines go?

I’m confused... what are the 2 transactions that are being counted? And is the end of the initial transaction implied?

I guess that’s reasonable logic, if it’s not a 0 it’s a 1

I may have picked the wrong answer, but I was right that it wouldn’t work. The basic concept would require the index to be completely rebuilt at least once every...

I confess, I had to look this up.  253 is just the Outgoing Keys, the incoming keys have a limit of 10,000!  That's a really important table to be referenced...

dhaveedh (6/21/2016)

---

Ken Hiatt (6/20/2016)

---

This was definitely wrong on many levels, but what strikes me is that they are expecting to extract a time from the first 8 characters of a...