I took this shot on vacation with my K10D using the bracketing function of three shots, each with a different exposure, one way under one right on and one way over exposed. I then put all three shots together with a HDR program, but not using the HDR function to get a shot I could not have taken with one exposure. The glare on the water alone was impossible, not to mention the dark shadows on the back side of the bridge.
I had to use the HDR program because I didn't have a tripod with me and the program stitched the 3 hand held shots together into one, since they were slightly off. It worked fairly well except for the moving cars on the bridge.