INSERT INTO @TABLE

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

Este ejercicio forma parte del curso

Writing Functions and Stored Procedures in SQL Server

Instrucciones del ejercicio

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.

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

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

Editar y ejecutar código