有两个案例陈述
Select
WhsCode,
ItemCode,
LotNumber,
ExpDate,
Qty
from rq_Test2
order by case when qty < 0 then Qty else null end ,
case when qty > 0 then ExpDate else NULL end
SQL Server算术溢出错误将表达式转换为数据类型datetime
有两个案例陈述
Select
WhsCode,
ItemCode,
LotNumber,
ExpDate,
Qty
from rq_Test2
order by case when qty < 0 then Qty else null end ,
case when qty > 0 then ExpDate else NULL end