The perform returns the 1st and very last title of a supplied BusinessEntityID and the Speak to variety for that individual. The CASE expression from the SET assertion decides the value to Display screen for that column ContactType dependant on the existence from the BusinessEntityID column in the Employee, Seller, https://collinqrphl.blogocial.com/pay-someome-to-do-case-study-can-be-fun-for-anyone-71590329