I Have Had Right Flank Pain Since October 24th. It's

I have had right flank pain since October 24th. It's sharp, and radiates to the middle of my back and down to my right buttocks. I have had two CT scans, one with contrast. I saw a urologist, he didn't seem very confident about his diagnosis of a UPJ obstruction. My doctor prescribed Vicodin and Flexeril. They aren't doing much to ease the pain.