Exercise

Use SP to INSERT

Create a stored procedure named cusp_RideSummaryCreate in the dbo schema that will insert a record into the RideSummary table with the result from the SumRideHoursSingleDay user defined function.

Instructions

100 XP

Create a stored procedure named cusp_RideSummaryCreate that accepts one input date parameter named @DateParm.
Pass @DateParm to the SumRideHrsSingleDay() user defined function.
Insert @DateParm and the result of SumRideHrsSingleDay() into the Date and RideHours columns of the RideSummary table.
Select the record that was just inserted.

Take Hint (-30 XP)