The function returns the initial and very last title of a given BusinessEntityID as well as Make contact with kind for that person. The CASE expression within the SET statement establishes the value to Show for your column ContactType dependant on the existence in the BusinessEntityID column in the Employee, https://jeffreydwhkm.blog2news.com/36527214/the-best-side-of-hire-someome-to-take-case-study