SELECT op.OutNo,op.OrderNo,op.ProductNo,Rtrim(p.strProductName) AS strProductName,p.strUnit,p.FloInLength,p.FloInWidth, p.FloInHeight,p.fAgio,pt.strtypedesc,pt.intPackRatein,pt.intPackRateMid,pt.intPackRateOut,o.PackType, (Case When pt.intPackRatein <>0 Then isnull(o.sl,0)/pt.intPackRatein End)as inBox, (Case When pt.intPackRatemidas <>0 Thenisnull(o.sl,0)/pt.intPackRatemidas End) midBox, (Case When pt.intPackRateOut <> 0 Then isnull(o.sl,0)/pt.intPackRateOut End)as outBox