Beware of ROW_NUMBER without ORDER BY

Haven’t posted all summer, but this bug pulled me straight out of the shadows. I recently faced a mystery that pushed me to the edge of despair. It seemed like a simple issue at first glance. A report kept changing completely at random. I spent a goo...