在where语句参数
的情况
select docket_number,aging from (
select docket_number,
sum(cast(dateDiff(\"mi\",assigned,coalesce(completed,getdate()))/60.00 as decimal(20,2))) aging
from ft_details_h
group by docket_number
)a where aging case when @hh <= 72 then <= @hh else > @hh end
嗨,大家好,当参数@hh小于或等于72时where语句应该老化<= @hh,而当老化大于72时where语句应该老化> @hh我如何满足where语句
没有找到相关结果
已邀请:
2 个回复
bab
硕歌沙
但我怀疑你有错字,实际上是