Session Ready
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.