[quote user="cdosrun"][quote user="don"]Oh, believe me, I have tons of my own WTFs. You have none?
Once you guys put me on to the fact that this is doing something I would have done with NOT EXISTS or NOT IN, I started looking at it more closely and found that, at least in this enviornment, this approach runs significantly ...
[quote user="don"]Reading through some production code written before I came to work at my present position, I found this query:
SELECT p.purchase_id FROM tbl_purchase AS p
LEFT JOIN tbl_history AS h ON h.purchase_id = p.purchase_id
LEFT JOIN tbl_item_purchase AS ip ON ip.purchase_id = p.purchase_id
LEFT JOIN tbl_code AS c ON ...
Yes, you're right. If I don't misspell anything it will search for only what I typed. [Without using Verbatim.][/quote]
So uh, any reason why you linked to another topic where a moron google user searched the exact wrong terms for what they really wanted to do? Google returned results for exactly ...
[quote user="joe.edwards"]I will frequently try to call up an article I've read before by typing the most unique phrase or coined word I can remember from it. This falls flat on its face as Google will "helpfully" change it to something more common.
Usually I'm deliberately trying to narrow the scope of my search in ...
[quote user="lolwtf"]Indeed, lately Google has gotten really bad at ignoring what you actually asked for, and instead giving you what it thinks you meant (which is nowhere near what you really meant).[/quote]
Except, he didn't ask for what he wanted. What the hell did he expect or want to get back when you put ASTLY instead of ...
[quote user="Ben L."]It's not so much the lack of knowledge as the refusal to acquire knowledge.
It looks to me like he was following up his question of "what does it do" with a specific "wat does require do" and had probably hit submit on his message before he saw or realized that you sent him a ...
A terrible way of validating that the ID exists in the table....
I thought it meant posts as in to a forum until I loaded the js file:
alert ("The postal code is not found in the default rate per cent. enter a new ZIP code.")
So not forum posts, postal code posts. Still pretty perverse!
To be honest, I'm surprised they didn't just take the same exact tables and copy them into a new schema named Star.
That way you have a Star Schema with all the data for your Data Warehouse. Clearly the best way to literally adhere to the standards.
Never seen or heard of heroku until I saw this sidebar forum post. So I decided to google it and find out what you're complaining about.
Turns out that you could read, well, anything on their site about "how it works" and have answered every question you just had in less time than it took to complain about ...