Declare multiple variables
You've seen how to DECLARE and SET set 1 variable. Now, you'll DECLARE and SET multiple variables. There is already one variable declared, however you need to overwrite this and declare 3 new ones. The WHERE clause will also need to be modified to return results between a range of dates.
This exercise is part of the course
Introduction to SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Declare @start
-- SET @start to '2014-01-24'