What movie had a detective investigating a crime scene and he found out he committed the crime?

Fallujah Marine: What movie had a detective investigating a crime scene and he found out he committed the crime?
He committed the crime because he had a split personality and was investigating himself but didnt know it. Thanks for the help.

Answers and Views:

Answer by Kristy
From Hell, with Johnny Depp.