SQL Show dates without transactions as value = 0

Programming in sql: SQL Show dates without transactions as value = 0 on newest questions tagged sql – Stack Overflow

I’m doing a weight reporting and I have a problem. I use this query to know the enters of weight in our warehouse, but when there are no transactions in a date this date doesn’t appears in the results.

SELECT  erp.MKPF.BUDAT AS Data,
Sum( erp.MSEG.MENGE * erp.MARM.BRGEW ) as pes 

From erp.MKPF
INNER Join erp.MSEG on erp.MKPF.MANDT = erp.MSEG.MANDT and erp.MKPF.MBLNR = erp.MSEG.MBLNR
INNER Join erp.MARM on erp.MSEG.MANDT = erp.MARM.MANDT and erp.MSEG.MATNR = erp.MARM.MATNR And erp.MSEG.MEINS = erp.MARM.MEINH
INNER JOIN erp.MARA on erp.MSEG.MANDT = erp.MARA.MANDT and erp.MSEG.MATNR = erp.MARA.MATNR

WHERE  erp.MKPF.MANDT = '100'
and erp.MKPF.BUDAT >= '20120720'
and erp.MKPF.BUDAT <= CONVERT(VARCHAR(8), GETDATE(), 112) -1
and erp.MSEG.LGORT in ('1001','1069')
and erp.MSEG.BWART In ('101','102','311','312')
and erp.MSEG.WERKS = '1001'
and erp.MARA.MTART in ('Z001','Z010','Z002','Z02E') 

GROUP BY erp.MKPF.BUDAT*

Now the results are like this:

Data        PES
20120720    9999999.9999
20120721    9999999.8888
20120723    9999999.7777

And i need this

Data        PES
20120720    9999999.9999
20120721    9999999.8888
20120722    0
20120723    999999.7777

Can somebody help me?

source: http://stackoverflow.com/questions/11611040/sql-show-dates-without-transactions-as-value-0
Programming in sql: programming-in-sql