However, Sherlock Holmes did die (at least Dr. Watson deducted so) in "The final problem", by falling down the [Reichenbach Falls]? in a death struggle with his arch-enemy, [Professor Moriarty]?. The next story (written about three years later) shows that he did not fall down, but that it only was set up by Holmes.
We can call this die-and-revive as the first case of the Bobby-Ewing-Effect? :-)
Anyway, not knowing about Inspector Morse, I feel not qualified enough to edit this article. Can anybody else do that? RedMabuse