suck-assed

adj.

Still drunk, and behaving like the least useful person in the room with misplaced confidence.

Source: Wiktionary