The functionality returns the initial and very last name of the offered BusinessEntityID as well as Get hold of kind for that person. The CASE expression during the SET statement decides the worth to Exhibit for the column ContactType depending on the existence in the BusinessEntityID column in the Employee, https://case-study-solution42784.blogsvirals.com/34924452/facts-about-hbs-case-solution-revealed