supposedly one of the Roman Consuls at Cannae was drunk...can't find any evidence for this though.

Napoleon's army looted vodka stores throughout the Russian campaign and lost many men by doing this, particularly on the way back. check MacDonnell 'Napoleon and His Marshals' for details, although there's loads of more detailed works on this.
The British army's barbaric sacking of both Badajoz and San Sebastian in 1812 and 1813 respectively were undoubtedly fuelled by the drinking before and during the assault, as was common in Wellington's army.

this page has a list of famous alcohol related deaths, including several heads of state.

http://en.wikipedia.org/wiki/List_of...hrough_alcohol