Exercise

CREATE PROCEDURE with OUTPUT

Create a Stored Procedure named cuspSumRideHrsSingleDay in the dbo schema that accepts a date and returns the total ride hours for the date passed.

Instructions

100 XP

Create a stored procedure called cuspSumRideHrsSingleDay in the dbo schema.
Declare @DateParm as the input parameter and @RideHrsOut as the output parameter.
Don't send the row count to the caller.
Assign the query result to @RideHrsOut and include the RETURN keyword.

Take Hint (-30 XP)