SYBASE12.5环境下,Truncation error occurred报错解决办法

SYBASE12.5环境下,Truncation error occurred报错
SELECT C.SKTNO,C.JLBH,LSDJ=SUM(LSDJ*XSSL),M.SKFS,SKJE=SUM(M.SKJE) INTO #123 
  FROM SKTXSJLC C,SKTXSJLM M
  WHERE C.SKTNO=M.SKTNO AND C.JLBH=M.JLBH
  AND [email protected] AND [email protected] AND M.SKFS=20
  GROUP BY C.SKTNO,C.JLBH,M.SKFS
  
  SELECT C.SKTNO,C.JLBH,C.SP_ID,C.BARCODE,C.LSDJ,C.XSSL,C.XSJE,C.LSDJ*C.XSSL-C.LSDJ*C.XSSL/A.LSDJ*A.SKJE,C.ZKJE,C.LSDJ*C.XSSL/A.LSDJ*A.SKJE,C.YHJE,0,C.ZKLX
  FROM SKTXSJLC C,#123 A
  WHERE C.SKTNO=A.SKTNO AND C.JLBH=A.JLBH

  DROP TABLE #123

以上查询语句在最后的SELECT语句查询结果只有一条记录时可以通过,多过一条时弹出了错误
"Truncation error occurred.
Command has been aborted."
不知道有没有高手遇到过同样问题~~希望有解决方法~
谢谢各位


------解决方案--------------------
错误应该发生在第一条语句！你可以尝试先truncate table #123或新建临时表,然后用语句
insert into #123
select ......
另外试试#123不要建主键,每列允许空值