techmixing.com
Case Statement/ Expression in SQL Server - Technology with Vivek Johari
This article on Case statement concept of SQL Server explain how we can use it to find one outcome out of many possible conditions