I went to the emergency at the hospital one night for that same pain. I was lucky that there just happened to be a pain specialist on duty that night, and he gave me nerve block injections right there at 3 AM! They really helped me a lot. They didn't hurt. However, there are different kinds of nerve blocks, so I guess it depends. It will probably be well worth any discomfort you may feel at the time. It gave immediate relief.
It did help lessen the spasms in my leg and made my leg numb, but it was better than that pain. I doubt you will be able to work as standing up or sitting is not good when you are having a flare up of sciatica, you probably don't need anyone to tell you that though! If you work regardless, at least you won't hurt so much.
What else really helped me was using those soft cold packs that you chill in the freezer. I would put one in a cotton sock (the cold wet plastic feels uncomfortable) and put it on the sciatic area, I would use 2 sometimes. I wore spandex shorts to hold the cold pack in place. (I wasn't going anywhere anyways) Then I wrapped a heating pad around my leg. Also, muscle relaxants and Tramacet, which is a low dose of Tramadol combined with Tylenol. I used Tramadol for a few weeks, but it made me sleep all the time, and have heart palpitations so I went off of it and took Tramacet instead
I also took Codeine and Tylenol. The doc tried a few things until we settled on the muscle relaxants and Tramacet. Also, anti-inflamatories, definitely helped a LOT! I think they helped more than the narcotics, as they helped reduce the inflammation around the sciatic nerve.
It took me months to recover, luckily I have adult kids who took care of me. By recover I mean, be able to walk without a walker. I kept with my exercises and used the cold packs as needed.
The pain doctor at the hospital had given me his card, so I went to the pain doctors clinic. I saw a different doctor who gave me marijuana pills. They did not do anything except make me feel a bit dizzy.
I was beginning to heal by that time anyways, (took ages to get in there) but I can go there for nerve blocks if I ever need then again, and now that they have seen me I can get in that day if urgent.
I had a physio therapist come to the house and she measured for a walker, which I found very helpful, as my leg dragged and I would fall without warning. Also bath grab bars and she wanted me to get a wheelchair bidet type thing but I said no, I have a small bedroom and can make it to the bathroom with the walker anyways.
It took months, exercise and basically laying on my bed for 5 months but I did eventually heal.
Sorry for the book.
Hope you get help, I know what agony nerve pain is.
Oh, nerve pain! I totally forgot. I take Neurontin, a seizure med. I take it for seizures, but every doctor I have seen for my pain has asked me if I had tried Neurontin for pain! I have no idea if it helps my pain, as I have been taking it far longer than I have had chronic pain.