Get startedGet started for free

NYC Borough statistics results

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

This exercise is part of the course

Writing Functions and Stored Procedures in SQL Server

View Course

Exercise instructions

  • 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.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Create SPResults
___ ___ ___(
  	-- Create Weekday
	___ nvarchar(30),
    -- Create Borough
	___ nvarchar(30),
    -- Create AvgFarePerKM
	___ nvarchar(30),
    -- Create RideCount
	___	nvarchar(30),
    -- Create TotalRideMin
	___	nvarchar(30))

-- Insert the results into @SPResults
___ ___ ___
-- Execute the SP
___ ___.___

-- Select all the records from @SPresults 
___ ___ 
___ ___;
Edit and Run Code