ТЕМА:

DECLARE @asc int;
SET @asc = 1; -- 1 - сортировка ASC, 0 - сортировка DESC

SELECT * FROM tbl1
ORDER BY 
CASE WHEN @asc = 1 THEN date_created END ASC, 
CASE WHEN @asc <> 1 THEN date_created END DESC;