The functionality returns the main and past name of the presented BusinessEntityID plus the Get in touch with variety for that particular person. The CASE expression within the SET assertion decides the worth to Exhibit for your column ContactType determined by the existence on the BusinessEntityID column in the Employee, https://landenlkwar.goabroadblog.com/34908229/not-known-facts-about-can-someone-take-my-case-study