只有10分了!今天写报表时出错,怎么办?详情请进!!!
执行以下语句里出错
daysphz 表里有160424条记录
------------------------------
select
isnull (ab.jwh,aa.jwh) as jwh,
isnull (ab.shishje,0) as shishje,
isnull (ab.maoli,0) as maoli,
isnull (aa.shishje,0) as shishje,
isnull (aa.maoli,0) as maoli
-------一月
from
(select a.jwh,sum(shishje) as shishje,sum(maoli) as maoli
from sp_kfmx a,daysphz b
where a.dspid=b.dspid and a.dkfid='DKF00000001' and
riqi>='2004-01-01' and riqi<='2004-01-31'
group by a.jwh) ab
-------二月
full join
(select a.jwh,sum(shishje) as shishje,sum(maoli) as maoli
from sp_kfmx a,daysphz b
where a.dspid=b.dspid and a.dkfid='DKF00000001' and
riqi>='2004-02-01' and riqi<='2004-02-20'
group by a.jwh) aa
on aa.jwh=ab.jwh
ODBC: 消息 0,级别 19,状态 1
SqlDumpExceptionHandler: 进程 51 发生了严重的异常 c0000005 EXCEPTION_ACCESS_VIOLATION。SQL Server 将终止该进程。