The functionality returns the first and last identify of a given BusinessEntityID as well as Get in touch with variety for that person. The CASE expression inside the Established assertion establishes the value to Exhibit for your column ContactType dependant on the existence with the BusinessEntityID column in the worker, https://can-someone-take-my-case73735.bloggerchest.com/35816244/new-step-by-step-map-for-hbr-case-studies