The House of Secrets #112 (October 1973) from DC Comics.
"The Case of Demon Spawn" by Writer Gerry Conway and Artist Luis Dominguez.
Roderick Doyle and Professor John Winston thinly veiled parodies of Sherlock Holmes and Doctor John Watson, find themselves taking on the Vampires in this strange 70s comic story.