在SQL Server 2008中解析全名

I know this is a common question and I've reads all the posts just cannot get it to work so here I am. I have a table called I know this is a common question and I've reads