Exercise

EXECUTE with OUTPUT parameter

Execute the dbo.cuspSumRideHrsSingleDay stored procedure and capture the output parameter.

Instructions

100 XP

Declare @RideHrs as a numeric output parameter.
Execute dbo.cuspSumRideHrsSingleDay and pass '3/1/2018' as the @DateParm input parameter.
Store the output parameter value in @RideHrs.
Select @RideHrs to show the output parameter value of the SP.