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
Exercise instructions
- Declare
@SPResults
as aTABLE
with the following columns ofnvarchar (30)
data types;Weekday
,Borough
,AvgFarePerKM
,RideCount
andTotalRideMin
. - 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
___ ___
___ ___;