Yes, very sorry that there's a few more people joining us here on this thread. I do recommend that you spend some time and go back to read the thread from the very beginning. It gives such a good picture of where many of us were when we first started this journey too.
Allykat.... yes, from your description it sounds like your DP is having a mTESE procedure (the most intrusive, but final straw) rather than a TESA (needle aspiration). Yes, bags of peas and those soft ice-packs will definitely be needed. The first 24 hours weren't too bad as he had lots of drugs still in his system, then dreadful for a couple of days, and yes, a good week before going back to work, but two weeks until he was feeling anywhere near normal again. We only got one sperm from it, which fertilised the egg, grew to day 5, but was a BFN. DH considered doing it a year later, but really we had moved on by then, and wouldn't put our hopes (and money) into such a slim chance. We've been using donor sperm ever since then, but thankfully, my DH was always open to using DS (he said he kind of knew that there was something wrong, blaming it on having large doses of steroids when he was a teenager due to some serious sporting injuries). It's all about taking one step at a time.