Sandford Rothman, a 63-year-old from Colorado, woke up to "a bang" and found he had shot himself in the knee while sleepwalking, the Daily Mail reported.