Obituary: /r/bicycling moderator no_numbers_here has passed away after being hit by a car

bicycling_community · 1 day

I did not know Harry, nor did I have any interactions with him here on reddit - but I am heartbroken to hear this. The only word I can think of to describe it is tragic.

initialsdrummer · 6 days

You might want to mention what day(s) you are filming? Also I would suggest posting to /r/Philadelphia too

TheTurner · 15 days

Not sure which guy's name you thought was weird - but Muggsy is just a nickname - his real name is Tyrone and Manute Bol was born in Sudan - other countries have different names.

GridironExperts · 16 days

Do you draft the coach by name or by team like defenses? If it is by name then the Saints should be interesting next year.

ChromeDeagle · 20 days

Simple Rule I follow: Unless you can see a baby's head cresting, never assume. Hasn't failed me yet.

DynamicArc · 21 days

Or like Linguo

dwu2 · 21 days

Absolutely - the top of the chart says the metric is percentage won of total championships contested. However, a team like the Marlins which has only existed since 1993 has only "contested" for 19 World Series. They have won 2 of them, so their bar should be out at 10.5 percent, instead of around 2.5 where they are now.

sedditrhit · 22 days

There is also this one: http://www.onewingtorule.com/

azzilla · 22 days

That line is from Jay and Silent Bob Strike Back.

azzilla · 22 days

There is no mention of Greedo shooting first or George Lucas messing with the trilogy in the original Clerks - George Lucas hadn't even messed with the trilogy yet (including making Greedo shoot first). Clerks came out in 1994. Star Wars Episode 4 Special Edition (when Lucas first started fucking with the trilogy and making Greedo shoot first) came out in 1997.

azzilla · 23 days

This is from Clerks 2

punkslime · 23 days

Wow - I hope you remember to remove them all if you ever sell the bike.

JihadDerp · 23 days

I may be in the minority, here, but I like the Bally's poker room. Smaller and quieter than Borgata.

ultimatechase · 23 days

Did you not notice that your clothes were a lot bigger on you than they used to be? I'm sure your waist size has shrunk significantly - aren't your pants falling off of you?

Rawwkit · 24 days

Socially Awkward Cosplayer:

Dresses up as Gordon Freeman

So he won't have to talk to anyone.

hollywood8550 · 25 days

Nicely done. One of these days I'll figure out how to re-attach my cadence sensor.

endgame-unknown · 25 days

If your husband owns a diamond necklace that says "Open Marriage"

master_of_none · 27 days

Why so focused on cursors? Generally speaking they are inefficient and there is often a better way to solve a problem that required them.

prawnhead · 27 days

Her?

prawnhead · 27 days

And they need to spell it correctly: FAO Schwarz

alchemie · 27 days

It's a combination of two different concepts.

SUM() does exactly what it sounds like - it'll sum up across the entire grouping the data you specify as its arguments.

If you're familiar with other programming languages, CASE should look familiar (or "SELECT CASE"). If not, it's just a different way of saying "IF, Then, Else".

So in this example we've said take all of the records that have the same itemrecordID, barcode, callnumber etc - go through each set and for every record, if it has an ActionTakenID of 13, add 1 to a total we're counting up - otherwise, add 0. The final total represents the number of checkouts for that ItemRecordID.

alchemie · 27 days

Try replacing your checkouts and renewals statements with this:

SUM(CASE WHEN irh.ActionTakenID = '13' THEN 1 ELSE 0 END) as Checkouts,  
SUM(CASE WHEN irh.ActionTakenID = '28' THEN 1 ELSE 0 END) as Renewals

And remove ActionTakenID from your group by.

fallingshoes · 28 days

He had wet dog smell - even when dry.

jaronkenney · 1 month

I hereby second "Happiest Baby on the Block" - read the book and/or watch the DVD. I don't know that I agree with the author's assessments of WHY his methods work ("the missing trimester" and all that - seems kind of pseudo-sciencey to me) but his methods DO work. Also, pick up a "Miracle Blanket" (http://www.amazon.com/Miracle-Blanket--Baby-Swaddling--Beige/dp/B000G0L2TM/ref=sr_1_1?ie=UTF8&qid=1335367521&sr=8-1) - it's the best swaddling blanket on the market and yet it doesn't get the attention it deserves.

redelman431 · 1 month

Actually, the convert code 106 gets pretty close to OP's desired formatting: http://msdn.microsoft.com/en-us/library/ms187928.aspx

SELECT CONVERT(VARCHAR, GetDate(), 106) will return "23 Apr 2012".

From there, to get it to OP's requested format you need only replace spaces with dashes:

SELECT REPLACE(CONVERT(VARCHAR, GETDATE(), 106), ' ', '-')

Five-Year Club	Beta Team IndexTank Search
Charter Member	Verified Email

hypo11

TROPHY CASE

hypo11

TROPHY CASE

you'll need to login or register to do that

create a new account

login