Get startedGet started for free

INSERT INTO @TABLE

Instead of storing static values in a table variable, let's store the result of a query.

This exercise is part of the course

Writing Functions and Stored Procedures in SQL Server

View Course

Exercise instructions

  • Declare a TABLE variable named @RideDates with the following columns RideStart and RideEnd.
  • Both table variable columns should be date data type.
  • SELECT the unique values of StartDate and EndDate from the CapitalBikeShare table. CAST them from datetime to date data types.
  • Store the query results in @RideDates.

Hands-on interactive exercise

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

-- Declare @RideDates
___ ___ ___(
    -- Define RideStart column
	___ ___, 
    -- Define RideEnd column
    ___ ___)
-- Populate @RideDates
___ ___ @RideDates(RideStart, RideEnd)
-- Select the unique date values of StartDate and EndDate
SELECT ___
    -- Cast StartDate as date
	___(___ as date),
    -- Cast EndDate as date
	___(___ as date) 
FROM CapitalBikeShare 
SELECT * 
FROM @RideDates
Edit and Run Code