注意关键点在TOP 99.999999 PERCENT
SELECT * FROM (
SELECT TOP 99.999999 PERCENT
t.CallDate,
t.userid,
t.GroupName,
t.AgentNum,
t.username,
t.duration,
t.connectNumber,
t.connectOrderNumber,
t.callnumber,
t.CallOrderNumber,
t.ConnectionRate,
t.OnlinSumbitNumber,
t.connectsuccessRate,
t.InputOrderNumber,
t.InputOrderRate,
t.SuccessOrderNumber,
t.SuccessRate,
t.FirstCallNumber,
t.TrackNumber
FROM @tab AS t WHERE t.userid IS NOT NULL
ORDER BY t.CallDate ASC ,
CASE WHEN @OrderType=101 THEN t.duration END ASC ,
CASE WHEN @OrderType=102 THEN t.duration END DESC ,
CASE WHEN @OrderType=111 THEN t.connectNumber END ASC ,
CASE WHEN @OrderType=112 THEN t.connectNumber END DESC ,
CASE WHEN @OrderType=121 THEN t.ConnectionRate END ASC ,
CASE WHEN @OrderType=122 THEN t.ConnectionRate END DESC ,
CASE WHEN @OrderType=131 THEN t.connectsuccessRate END ASC ,
CASE WHEN @OrderType=132 THEN t.connectsuccessRate END DESC ,
CASE WHEN @OrderType=141 THEN t.InputOrderNumber END ASC ,
CASE WHEN @OrderType=142 THEN t.InputOrderNumber END DESC ,
CASE WHEN @OrderType=151 THEN t.InputOrderRate END ASC ,
CASE WHEN @OrderType=152 THEN t.InputOrderRate END DESC ,
CASE WHEN @OrderType=161 THEN t.SuccessOrderNumber END ASC ,
CASE WHEN @OrderType=162 THEN t.SuccessOrderNumber END DESC ,
CASE WHEN @OrderType=171 THEN t.SuccessRate END ASC ,
CASE WHEN @OrderType=172 THEN t.SuccessRate END DESC ,
CASE WHEN @OrderType=181 THEN t.FirstCallNumber END ASC ,
CASE WHEN @OrderType=182 THEN t.FirstCallNumber END DESC,
CASE WHEN @OrderType=191 THEN t.TrackNumber END ASC ,
CASE WHEN @OrderType=192 THEN t.TrackNumber END DESC
) AS tt
UNION ALL
SELECT * FROM (
SELECT TOP 99.999999 PERCENT
t.CallDate,
t.userid,
t.GroupName,
t.AgentNum,
t.username,
t.duration,
t.connectNumber,
t.connectOrderNumber,
t.callnumber,
t.CallOrderNumber,
CASE WHEN t.CallDate=N'合计' then null ELSE t.ConnectionRate end as ConnectionRate,
t.OnlinSumbitNumber,
CASE WHEN t.CallDate=N'合计' then null ELSE t.connectsuccessRate end as connectsuccessRate,
t.InputOrderNumber,
CASE WHEN t.CallDate=N'合计' then null ELSE t.InputOrderRate end as InputOrderRate,
t.SuccessOrderNumber,
CASE WHEN t.CallDate=N'合计' then null ELSE t.SuccessRate end as SuccessRate,
t.FirstCallNumber,
t.TrackNumber
FROM
@tab AS t WHERE t.userid IS NULL ORDER BY t.CallDate ASC
) AS v