Create Cumulative Count of Records in script by date

[mikelees80]

So I've been asked to provide cumulative count of our products we have installed by date. I need to to make sure we include date even if we haven't installed anything on that that. I already have a calendar QVD I can leverage.

This needs to be a script because I need to then link this new table to a different data set

Example of installed list

Account	InstallDate	Serial Number
12345	15/07/2017	10
12345	16/07/2017	11
12345	19/07/2017	12
12345	25//07/2017	13
12345	29/07/2017	14
12345	02/08/2017	15
12345	05/08/2017	16
12345	10/08/2017	17
12345	12/08/2017	18

Example of Output

Date	Account	Count
01/07/2017	12345	0
02/07/2017	12345	0
03/07/2017	12345	0
04/07/2017	12345	0
05/07/2017	12345	0
06/07/2017	12345	0
07/07/2017	12345	0
08/07/2017	12345	0
09/07/2017	12345	0
10/07/2017	12345	0
11/07/2017	12345	0
12/07/2017	12345	0
13/07/2017	12345	0
14/07/2017	12345	0
15/07/2017	12345	1
16/07/2017	12345	2
17/07/2017	12345	2
18/07/2017	12345	2
19/07/2017	12345	3
20/07/2017	12345	3
21/07/2017	12345	3
22/07/2017	12345	3
23/07/2017	12345	3
24/07/2017	12345	3
25/07/2017	12345	4
26/07/2017	12345	4
27/07/2017	12345	4
28/07/2017	12345	4
29/07/2017	12345	5
30/07/2017	12345	5
31/07/2017	12345	5
01/08/2017	12345	5
02/08/2017	12345	6
03/08/2017	12345	6
04/08/2017	12345	6
05/08/2017	12345	7
06/08/2017	12345	7
07/08/2017	12345	7
08/08/2017	12345	7
09/08/2017	12345	7
10/08/2017	12345	8
11/08/2017	12345	8
12/08/2017	12345	9
13/08/2017	12345	9

Any ideas on how to produce this would be great

[mikelees80]

great it works!!!