- Stack Exchange Data Explorer

declare @t table (SortColumn int) insert @t values (1),...

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programmers

-- Enter Query Title
-- Enter Query Description


declare @t table (SortColumn int)
insert @t values (1), (2), (3)
declare @asc bit
set @asc = 1

select * from @t
order by
--    case when 1=1 then SortColumn end asc,
--    case when 1=0 then SortColumn end desc
    case when @asc=1 then SortColumn end asc,
    case when @asc=0 then SortColumn end desc

--select  row_number() over (order by
--            case when 1=1 then SortColumn end asc,
--            case when 1=0 then SortColumn end desc) rn1
--            case when @asc=1 then SortColumn end asc,
--            case when @asc=0 then SortColumn end desc) rn1
--,       *
--from    @t

created aug 27 11