I have a mate who does it quite a bit. Like you Si, it's when he's been drinking that it mostly happens.
One time he went into his flatmates room at uni and was just about to piss in the wardrobe, but got stopped in time. Why do they always pick the wardrobe to do a toilet in?
Another time he went to a big party and the plan was to sleep in his car. He got completely battered, but just about remembered going to sleep. When he woke up he had moved his car about twenty yards so it was parked next to his mate. Parked perfectly.
Thing is, this isn't really sleep walking in these cases with drink involved, it means your not quite trashed enough to sleep through and piss the bed, so you are aware you need to go,but not quite lucid enough to go in the right place. Genuine sleepwalking doesnt involve alcohol, and is not nearly as funny!