Yep, been there, done that. Got a friend who gets them so often it doesn't even bother him much. He's probably got a small quarry in his septic tank. Truly is agony in one of its higher forms. Never had them bad enough to need lithotripsy or anything. Like a hot knife in the mid to lower back, followed by the distinct impression you're pissing a strand of barbed wire.
We went on a trip to a trade show a couple years ago, and my friend said "Hey, you gotta drive, I got another rock". So I took over driving, and he took a pain pill and proceeded to drink about 10 12oz. beers. We pulled over to take a leak and you could actually here the stone hit the urinal. He just laughed and said "got ya, ya little bastard". He slept two hours and was fine. I just ain't that tough when I get one. Takes me at least 8 hours to pass it, and I'm sick and trying to sleep the whole time.