Exercise

INSERT INTO @TABLE

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

Instructions

100 XP

Create a TABLE variable named @RideDates with the following columns - RideStart and RideEnd - both of date data type.
Select the unique date values of StartDate and EndDate from the CapitalBikeShare table.
Store the query results in `@RideDates.

Take Hint (-30 XP)