Eliminating zero sum while inserting

[hedgracer]

Here is the sql statement:

Insert into BEGACCOUNTINFO (ACCOUNT, ACCOUNTNAME, ENDBAL)
select ACTNUMST,ACTDESCR,SUM(PERDBLNC)
FROM [EQU-SRV-DB].RCG.dbo.Actg_1FR
WHERE PERIODID <= '02'
GROUP BY ACTNUMST, ACTDESCR
ORDER BY 1;

I would like to eliminate any rows wher sum(perdblnc) is 0 while inserting. How would I do that in this statement? Thanks for all help in advance.

Dave

 

[gmmastros]

Insert into BEGACCOUNTINFO (ACCOUNT, ACCOUNTNAME, ENDBAL)
select ACTNUMST,ACTDESCR,SUM(PERDBLNC) 
FROM [EQU-SRV-DB].RCG.dbo.Actg_1FR
WHERE PERIODID <= '02'
GROUP BY ACTNUMST, ACTDESCR
[!]Having Sum(PERDBLNC) > 0[/!]
ORDER BY 1;

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ClaireHCM]

I can't do testing. But give it a shot,

Insert into BEGACCOUNTINFO (ACCOUNT, ACCOUNTNAME, ENDBAL)
select ACTNUMST,ACTDESCR,SUM(PERDBLNC)
FROM [EQU-SRV-DB].RCG.dbo.Actg_1FR
WHERE PERIODID <= '02'
GROUP BY ACTNUMST, ACTDESCR having SUM(PERDBLNC) > 0
ORDER BY 1;