Question

SQL Server SUM GROUP BY 返回错误答案

SELECT je.CompanyCode
,je.ItemId
,je.DocId
,SUM(tb.DebitEOY + tb.CreditEOY) --为什么该列返回值会是期望值5倍？
FROM dbo.JE je
,dbo.TB tb
,(select *
from dbo.JE j
where j.DateOfDoc between @Yr + '-10-01' and @Yr + '-12-31') je3
WHERE je.CompanyCode = tb.CompanyCode
AND je.ItemId = tb.ItemId
AND je.CompanyCode = je3.CompanyCode and je.ItemId = je3.ItemId
GROUP BY je.CompanyCode
,je.ItemId
,je.DocId
HAVING SUM(tb.DebitEOY + tb.CreditEOY) != 0
ORDER BY je.CompanyCode
,je.ItemId
,AgingAR3

Answer 1

添加一个sScrollY属性
var height=$(window).height();

$(document).ready(function() {
$('#example').dataTable(
{
"sScrollY": height
});