The functionality returns the first and very last identify of a supplied BusinessEntityID plus the Get hold of form for that person. The CASE expression inside the Established statement decides the value to Screen for the column ContactType depending on the existence on the BusinessEntityID column in the worker, Seller, https://griffinufxwl.bcbloggers.com/34988587/facts-about-hbs-case-solution-revealed