"Murphy was an optimist!"
January 3, 2009 3:31 pm
Posted by utterz in : Daily Life, Podcasting
Mobile post sent by djuggler using Utterli. Replies.
Monkfish January 2, 2009 3:13 pm
Posted by utterz in : Daily Life, Podcasting
Is Yellowstone about to kill a lot of the world’s population? January 2, 2009 2:02 pm
Posted by Doug McCaughan in : Environment, Touchy SubjectsWell, maybe…
add a commentit’s been 600,000-ish years since Yellowstone’s supervolcano has gone off full blast…
Picture 1,000 Mount Saint Helenses…
A supereruption could kill tens of millions.
More than half the U.S. will experience ashfall, potentially fatal if inhaled.
…could devegetate a third of the lower 48 (including some of the world’s most productive farmland) for years or decades, leading to mass starvation…
Within 10 to 50 miles of the next Yellowstone vent, you’ll be Pompeiiized…
What’s the chance of a supereruption anywhere in the world in the next 50 years? Estimates range from one chance in 1,000 to one in 10,000 — hardly cause for panic.[Source, The Straight Dope, Is Yellowstone Park sitting on a supervolcano that’s about to blow?]
Today’s Technical Brain Cloud January 2, 2009 11:39 am
Posted by Doug McCaughan in : MySQL, Programming, TechnologyHaving a stupid moment and maybe you can help. I’m trying to count how many times an employee is scheduled using MySQL. I would like to have a column that for George says "3" and for Lucy says "2" but if I group on EmployeeID and use count(e.EmployeeID) I end up with 2 rows instead of 5. How do I retain the 5 rows of data and still get a count of 3 for George and 2 for Lucy? My output will show that George has schedule Sat-Mon, Tues-Fri, and Wed-Sun and will say "George is scheduled 3 times."
CompanyID AffiliateID EmployeeID EmployeeName Schedule
1 23 11 George Sat-Mon
1 23 11 George Tues-Fri
1 23 11 George Wed-Sun
1 23 15 Lucy Sun-Mon
1 23 15 Lucy Thur-FriSELECT c.CompanyID,
a.AffiliateID,
e.EmployeeID,
e.EmployeeName,
s.Schedule
FROM companies c
LEFT OUTER JOIN subscription s
ON c.CompanyID = s.CopmanyID
LEFT OUTER JOIN affiliates a
ON a.AffiliateID = s.AffiliateID
LEFT OUTER JOIN employees e
ON ae.AffiliateID = a.AffiliateID
LEFT OUTER JOIN schedules s
ON s.EmployeeID = e.EmployeeID
AND s.CompanyID = c.CompanyID
AND s.AffiliateID = a.AffiliateID
WHERE (s.StartDate <= FROM_UNIXTIME(1227243599)
AND s.EndDate >= FROM_UNIXTIME(1227157200))
AND c.CompanyID = 1
ORDER BY c.CompanyName, s.AffiliateID ASC
I know this is not a complex SQL problem. I’ve done this in the past but today I am being dense and am stumped.
4commentsRobin Williams on Obama’s Election January 2, 2009 10:01 am
Posted by Doug McCaughan in : Humor, Philosophy, Politics, Touchy Subjects, United StatesHow did I miss this! 2,584,449 views at the time of posting which probably means Youtube will pull it soon.
Seen on Political Irony.
2commentsWhere’s my list? January 1, 2009 9:02 pm
Posted by Doug McCaughan in : Blog, PublishingI toyed with getting on the bandwagon with a stats post showing all the hits and search terms and referrers used to get to Reality Me in 2008, but after looking at it, I figured out that people pretty much come here looking for information on the New Madrid fault, the RealTek 8201CL driver, and condoms.
2comments
