NYC Borough statistics results

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

Este exercício faz parte do curso

Writing Functions and Stored Procedures in SQL Server

Instruções do exercício

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.

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

-- 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 
___ ___ 
___ ___;

Editar e executar o código