Untitled
unknown
plain_text
2 years ago
457 B
6
Indexable
DECLARE @DepartureCity VARCHAR(50) = 'YourDepartureCity'; DECLARE @ArrivalCity VARCHAR(50) = 'YourArrivalCity'; SELECT DATEADD(DAY, 1, GETDATE()) AS Date, CONVERT(VARCHAR(5), flight_time, 108) AS Time, flight_number AS Flight FROM flights_table WHERE departure_city = @DepartureCity AND arrival_city = @ArrivalCity AND flight_date BETWEEN DATEADD(DAY, 1, GETDATE()) AND DATEADD(DAY, 20, GETDATE()) ORDER BY flight_date ASC;
Editor is loading...