Here are some of my choices of television scenes where I thought music was used in a particularly inventive fashion. If you have others, please drop the links into the comments or just recall them from memory. Hope you enjoy these!
Beatles - All You Need Is Love - The Prisoner
Dire Straits - Brothers in Arms - West Wing
Grateful Dead - Ripple - Freaks and Geeks
Patti Smith - Horses - Millennium