The purpose returns the initial and final identify of a supplied BusinessEntityID along with the Make contact with sort for that person. The CASE expression from the SET statement establishes the value to display to the column ContactType dependant on the existence of your BusinessEntityID column in the worker, Seller, https://rowanlbzvv.fare-blog.com/36089682/the-fact-about-can-someone-do-my-case-study-that-no-one-is-suggesting