I have to share a story.
One particularly frustrating week of working on endless SQL’s caused a glitch in the Matrix for me.
I had been working on a couple of small reports which had to be done yesterday! And, one rather large report which was seriously pissing me off. No matter what I did I could not get the large report to run. It was error after error after error after error….enough to drive you to drinking!
I finished up the two smaller reports. Decided I’m leaving the large report for the next day because I’d had it. I was just mentally done with fighting with it.
Went home that night. Relaxed. Watched TV. Went to bed.
Woke up from a horrible dream at 3 am. In my dream I had accidentally deleted the large report. Upper management was wielding pitch forks and torches, and chasing me down a road I’d never seen.
The whole time I’m running I am retyping this huge query. Trying to get it finished before they catch me. The running and typing thing is a super power I do not posses in real life. Thankfully, I get the last line typed and …they catch me before I can tell them I’m finished…and….that’s when I woke up.
I get to work the next day. Finally stop procrastinating and decide I’d better work on the large report before there really are pitchforks and torches. So, I open the query and run it to see what errors I need to resolve and…the stupid thing runs!! Not a single error in sight.
I validate the data. It’s spot on. The client is happy. I’m confused.
I have to admit though, it is not the first time I’ve written a query in my sleep!