I've had a LOT of conversations like this with friends.
Here is what you do.... listen ONE FVCKING TIME. Let him vent, let him get drunk off his @ss, BTW YOU need to stay sober, hold his head when he's puking, drive him home, roll him into bed. Then the next time he brings this up tell him...