The purpose returns the 1st and last title of the specified BusinessEntityID as well as Make contact with style for that individual. The CASE expression inside the SET statement determines the value to Screen with the column ContactType dependant on the existence of your BusinessEntityID column in the worker, Vendor, https://juliusdaqcf.tinyblogging.com/the-5-second-trick-for-hbs-case-solution-79577593