The perform returns the initial and last identify of a specified BusinessEntityID and also the contact type for that person. The CASE expression within the SET statement determines the worth to Show for that column ContactType dependant on the existence of your BusinessEntityID column in the worker, Vendor, or Consumer https://findsomeonetotakemycasest08172.tinyblogging.com/the-fact-about-can-someone-do-my-case-study-that-no-one-is-suggesting-79613719