Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a user-defined function fnSalesPersonName that will return for any sales order header the name of the sales person (concatenated string containing First, Middle and
Create a user-defined function fnSalesPersonName that will return for any sales order header the name of the sales person (concatenated string containing First, Middle and Last Name) of the salesperson associated with a sales order id (or N/A if there is no salesperson) retrieved from the person table as specified in the SalesOrderHeader table. The parameter should be the sales order id with the function returning a string containing the appropriate sales persons name.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started