Test FUNCTIONs
Now it's time to test the three functions you wrote in the previous exercise.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Display the first 100 records of
PickupDate
,TripDistance
andFareAmount
fromYellowTripData
. - Determine the shift value of
PickupDate
by passing the hour value todbo.GetShiftNumber
function; display the shift and include it in theWHERE
clause for shifts = 2 only. - Convert
TripDistance
to kilometers withdbo.ConvertMiletoKm
function. - Convert
FareAmount
to Euro (with exchange rate of 0.87) with thedbo.ConvertDollar
function.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Select the first 100 records of PickupDate
TOP 100 ___,
-- Determine the shift value of PickupDate
dbo.___(___(___, ___)) AS 'Shift',
-- Select FareAmount
FareAmount,
-- Convert FareAmount to Euro
dbo.___(___, 0.87) AS 'FareinEuro',
-- Select TripDistance
TripDistance,
-- Convert TripDistance to kilometers
dbo.___(___) AS 'TripDistanceinKM'
FROM YellowTripData
-- Only include records for the 2nd shift
WHERE dbo.___(___(___, ___)) = 2;