The function returns the initial and past identify of the specified BusinessEntityID and also the Get in touch with form for that person. The CASE expression inside the SET assertion determines the value to Exhibit with the column ContactType dependant on the existence of your BusinessEntityID column in the Employee, https://milojvvbc.kylieblog.com/36504240/5-simple-statements-about-case-help-explained