anxious! !! Urgent !! urgent !! rookie online waiting for a simple sql

alphao0

select sum (DocCount) as DocCount,
MAX (convert (int, SignSendDate)) as CompleteDate from ArchiveInfos
where docID in (select DocID from DocArchiveItems where InfoID = '00000000000000000019') and sourcetype = '1'

   How to make doccount = 0 when docCount is null, and equal to the sum when it is not null

cv4bf5d65fd

select sum(isnull(DocCount,0)) as DocCount,
MAX(convert (int,SignSendDate)) as CompleteDate from ArchiveInfos
where docID in( select DocID from DocArchiveItems where InfoID='00000000000000000019') and sourcetype='1'

cv4bf5d65fd

isnull(column name, 0)

alphao0

I'm judging that the value of the field after sum isnull doesn't seem to work

alphao0

Wrongly written just now ha ha ha thank you

恶魔右指

select sum(DocCount) as DocCount
Change it
select DocCount=case when sum(DocCount)!=0 then sum(DocCount) else''end