sql server case when then

http://blog.csdn.net/wuxiaokaixinguo/article/details/8895187