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

Exercise

NYC Borough statistics results

Let's see the results of the dbo.cuspBoroughRideStats stored procedure you just created.

Instructions

100 XP
  • Declare @SPResults as a TABLE with the following columns of nvarchar (30) data types; Weekday, Borough, AvgFarePerKM, RideCount and TotalRideMin.
  • Execute dbo.cuspBoroughRideStats and insert the results into @SPResults.
  • Select all the records from @SPresults.