The purpose returns the very first and final identify of a specified BusinessEntityID and also the Make contact with style for that particular person. The CASE expression in the SET statement establishes the value to Display screen for that column ContactType based on the existence of the BusinessEntityID column in https://casehelp89419.pages10.com/hbs-case-study-help-no-further-a-mystery-71184145