怎样在视力中实现查询结果向上取整

Question

请问各位高手：
    在不在，请教一个问题,我在执行查询视图的时候，想达到一种效果，就是两个字段相除，如遇除不尽的时候向上取整，如遇能够除尽的时候，就是当前整数：
如：9除3=3，如9除以22=5，11除以2=6，11除以3=4 怎么实现，而我用了CEILING()函数,但结果不对,你有什么办法吗?
我的查询语句是这样的:
SELECT dbo.xsjihua.xskehdaim AS 客户, dbo.xsjihua.xskedingdhao AS 订单号, 
      dbo.xsjihua.xskehxingh AS 客户型号, 
      qiangli3rd.dbo.SuiGongDan.suigd_biaozhunxinghao AS 标准型号, 
      dbo.Gbaozhuangxuqiu.gbaozhuangdaima AS 包装代码, 
      dbo.Gbaozhuangxuqiu.gshuliang AS 数量, 
      qiangli3rd.dbo.SuiGongDan.suigd_suidanhao AS 生单号, 
      qiangli3rd.dbo.SuiGongDan.suigd_jitshu AS 投坯数, 
      CEILING(qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang) 
      AS 计领数, dbo.Gbaozhuangxuqiu.gdanwei AS 单位, 
      qiangli3rd.dbo.SuiGongDan.suigd_chejian AS 车间, 
      qiangli3rd.dbo.SuiGongDan.suigd_zscjihID AS 生产计划ID, 
      dbo.Gbaozhuangxuqiu.gbaozhuangID AS 包装ID, 
      dbo.Gbaozhuangxuqiu.xsfahjihriq AS 计划发日, 
      dbo.Gbaozhuangxuqiu.zscqianxwanq AS 机加完期, 
      dbo.Gbaozhuangxuqiu.zscpijwanq AS 坯件完期, 
      dbo.Gbaozhuangxuqiu.xsxiadanri AS 销下单日, 
      dbo.Gbaozhuangxuqiu.xsjiaohuqi AS 交货期, 
      qiangli3rd.dbo.SuiGongDan.suigd_suidanhao1 AS 随单号
FROM qiangli3rd.dbo.SuiGongDan LEFT OUTER JOIN
      dbo.Gbaozhuangxuqiu ON 
      qiangli3rd.dbo.SuiGongDan.suigd_zscjihID = dbo.Gbaozhuangxuqiu.zscjihID LEFT OUTER
       JOIN
      dbo.xsjihua ON dbo.Gbaozhuangxuqiu.xsjihID = dbo.xsjihua.xsjihID
WHERE (qiangli3rd.dbo.SuiGongDan.suigd_shenhefen = 1)
画横线的地方就是我想让结果向上取整，而查询来的结果让我非常失望，结果却是向下取整，我该怎么实现这一效果，望各位高手多多指教
 
！

Answer 1

CEILING(qiangli3rd.dbo.SuiGongDan.suigd_jitshu*1.0 / dbo.Gbaozhuangxuqiu.gshuliang) 
AS 计领数

Answer 2

 CEILING(qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang /1.0) 
AS 计领数

Answer 3

case when qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang - floor(qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang) > 0
          then floor(qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang) + 1
          else floor(qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang)
end
AS 计领数

Answer 4

谢谢各位，三楼的答案接近正确答案，但也能解决实际问题，有点复杂，但经我仔细考虑与推算，正确答案应该是这样的，
qiangli3rd.dbo.SuiGongDan.suigd_jitshu / dbo.Gbaozhuangxuqiu.gshuliang + CASE WHEN
       qiangli3rd.dbo.SuiGongDan.suigd_jitshu % dbo.Gbaozhuangxuqiu.gshuliang = 0 THEN
       0 ELSE 1 END AS 计领数