Exercise

Multiple inputs one output

Often times you will need to pass multiple parameters to a function. Create a function that accepts both StartDate and EndDate then returns the total ride hours for all transactions that occur within the parameter values.

Instructions

100 XP

Create a function named SumRideHrsDateRange with @StartDateParm and @EndDateParm as the input parameters of datetime data type.
Specify the return data type to be numeric.
Use a select statement to sum the difference between the StartDate and EndDate of the transactions.
Only include transactions that have a StartDate greater than @StartDateParm and less than @EndDateParm.

Take Hint (-30 XP)