Build User-Defined Functions




Using SQL Server AdventureWorks2014 database. The assignment is to build User-Defined Functions

Your manager has determined that a function should be created to allow easy access to a list of company e-mail addresses and phone numbers. While this serves as a practical tool for quick extraction of this information, it can also be joined to other queries as needed for more complex queries.

Create the SQL query code used to explore the database tables and construct a complex function called “ContactList.” Access seven tables for this function using multiple joins. Layout is an important consideration, particularly for debugging if errors are encountered. The function should call BusinessEntityID, Employee (Last + First Name), Job Title, Department, Type (Cell, Work, etc.), Phone Number, and Email Address. Run the function once you have completed it.