1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server

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.