pissed idiot

Someone who can't handle their booze and carries on like a complete bellend.

Everytime he drinks, Nick turns into nothing but a pissed idiot.