2.7k views
3 votes
Create a table-valued function named fnDateRange, similar to the stored procedure of exercise 3. The function requires two parameters of data type smalldatetime. Don't validate the parameters. Return a result set that includes the InvoiceNumber, InvoiceDate, InvoiceTotal, and Balance for each invoice for which the InvoiceDate is within the date range. Invoke the function from within a SELECT statement to return those invoices with InvoiceDate between December 10 and December 20, 2011.

User BillW
by
4.4k points

1 Answer

2 votes

Answer:

Please see the attached picture for the complete answer.

Step-by-step explanation:

Create a table-valued function named fnDateRange, similar to the stored procedure-example-1
User Fokrule
by
3.9k points