The operate returns the primary and last name of a offered BusinessEntityID as well as Get hold of kind for that human being. The CASE expression in the SET statement decides the value to Display screen with the column ContactType based on the existence from the BusinessEntityID column in the https://case-study-help90898.blogsuperapp.com/36493191/the-single-best-strategy-to-use-for-find-someone-to-do-case-study