I know it's the US of A, but when I watch soccer I just feel like I'm watching the sport that the rest of the World failed to turn into what is actually Football or something.
Go in to see Doctor. Tell him that you are having troubles sleeping and that you've tried over the counter drugs to see if they'll help but they don't and they leave you extra drowsy all day the next day.
Then tell him this exactly: "I was visiting my Grandparents from out of state and I was having trouble sleeping and really needed to get some sleep for the next day. So my Grandpa gave me 5mg of Zolpidem and it did the trick perfectly. Since then I've tried it on a couple of other occasions and it worked like a charm. It's the only thing that helps my insomnia."
He might talk about his concerns with prescribing the drug as it can become addictive, but ultimately he will prescribe it. It's just a generic drug that costs peanuts.