The functionality returns the primary and very last name of the specified BusinessEntityID along with the Get in touch with style for that human being. The CASE expression while in the SET statement determines the worth to Show to the column ContactType based upon the existence of your BusinessEntityID column https://andresethha.p2blogs.com/34683341/fascination-about-case-study-help