Exercise

One in one out

Create a function named SumRideHrsSingleDay() which returns the total ride time in hours for the @DateParm parameter passed.

Instructions

100 XP

Define input parameter of type date - @DateParm and a return data type of numeric.
Use BEGIN/END keywords.
In your SELECT statement, SUM the difference between the StartDate and EndDate of the transactions that have the same StartDate value as the parameter passed.
Use CAST to compare the date portion of StartDate to the @DateParm.