Maybe a can or two a day, though more if there's Throwback around (Yes, I can tell the difference between syrupy ultra-sweet Corn Syrup and nice, natural sugar). Always with meals, maybe one slipped in if it sounds good. I used to guzzle it a lot when I was younger, though and it's one of the reasons I'm still pudgy.
I prefer tea if I can get it, though some is just as unhealthy as soda (though I still love you Sobe Green Tea). For whatever reason, I don't enjoy water with meals though I drink plenty during the course of a day.
Water with dinner means I'm ordering from the bar and roughly translates to "This is to wash things down while you take 10 minutes to get your ass back here with my drink."
I've tried going to diet sodas, but they start to taste the same after a while and are quite god awful. I seem to recall reading that the 'fake sugar' in diet sodas screws up the body more than regular sugar when it comes to diabeeetus, but honestly if I'm going to put shit in my body, I might as well enjoy the taste of it.