The Heap™ – Consultancy ©®

« first day (1516 days earlier) ← previous day next day → last day (3345 days later) »

1:24 AM

Your code worked the first time, without edit. I didn't know about ROW_NUMBER() OVER ... PARTITION, so that's a new trick for me. You're right, it seems relatively straightforward with that in hand. But, you also pointed me to some new tools, and to a book's worth of material to read about all the related issues. I don't think there's more that could be done with a single answer. A+++. Would ask again. — David Krider 4 hours ago

1 hour later…

swasheck

2:53 AM

@ypercube that was an excellent @PaulWhite answer. however ... his "related answer" link is solid gold

1 hour later…

swasheck

4:05 AM

uber hacked ... i think i found their problem

> Business logic all lives in an API built on Python, MySQL and Mongo.

ypercube

Ha. TomTom to the rescue: dba.stackexchange.com/posts/86670/revisions

(of Microsoft by the the insulting Thomas Kejser ;)

swasheck

4:20 AM

nice

2 hours later…

Paul White

6:44 AM

@SimonRigharts Yes, real soon. Assuming no actual heart attack tonight following that match.

Simon Righarts

@PaulWhite Kane for PM IMO.

Paul White

With McCullum & McCaw as join kings, yes.

#SteadyTheShip

Simon Righarts

@PaulWhite (there'll be one, maybe two other people in the chat that actually understand what we're talking about. For those that don't -- cricket. The World Cup is on and we only just beat Australia.)

@PaulWhite I dunno if that was steadying the ship so much as frantically paddling to shore before it completely sunk, but yeah

Paul White

That catch clearly hit the grass, obviously. My goodness there would have been riots if we had lost.

Simon Righarts

I thought cricket supporters were all too well-mannered to riot?

Besides all we'd lose would be Auckland, NBD

Paul White

6:50 AM

True!

1 hour later…