add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @estimated_daily_sales integer = 2;
DECLARE @starting_balance integer = 12345;

WITH
cte AS
(
SELECT 0 i
UNION ALL
SELECT i + 1 i
FROM cte
WHERE i + 1 <= 120
)
SELECT dateadd(day, i, convert(date, getdate())) day,
@starting_balance - i * @estimated_daily_sales balance
FROM cte
OPTION (MAXRECURSION 120);
day balance
03/10/2018 00:00:00 12345
04/10/2018 00:00:00 12343
05/10/2018 00:00:00 12341
06/10/2018 00:00:00 12339
07/10/2018 00:00:00 12337
08/10/2018 00:00:00 12335
09/10/2018 00:00:00 12333
10/10/2018 00:00:00 12331
11/10/2018 00:00:00 12329
12/10/2018 00:00:00 12327
13/10/2018 00:00:00 12325
14/10/2018 00:00:00 12323
15/10/2018 00:00:00 12321
16/10/2018 00:00:00 12319
17/10/2018 00:00:00 12317
18/10/2018 00:00:00 12315
19/10/2018 00:00:00 12313
20/10/2018 00:00:00 12311
21/10/2018 00:00:00 12309
22/10/2018 00:00:00 12307
23/10/2018 00:00:00 12305
24/10/2018 00:00:00 12303
25/10/2018 00:00:00 12301
26/10/2018 00:00:00 12299
27/10/2018 00:00:00 12297
28/10/2018 00:00:00 12295
29/10/2018 00:00:00 12293
30/10/2018 00:00:00 12291
31/10/2018 00:00:00 12289
01/11/2018 00:00:00 12287
02/11/2018 00:00:00 12285
03/11/2018 00:00:00 12283
04/11/2018 00:00:00 12281
05/11/2018 00:00:00 12279
06/11/2018 00:00:00 12277
07/11/2018 00:00:00 12275
08/11/2018 00:00:00 12273
09/11/2018 00:00:00 12271
10/11/2018 00:00:00 12269
11/11/2018 00:00:00 12267
12/11/2018 00:00:00 12265
13/11/2018 00:00:00 12263
14/11/2018 00:00:00 12261
15/11/2018 00:00:00 12259
16/11/2018 00:00:00 12257
17/11/2018 00:00:00 12255
18/11/2018 00:00:00 12253
19/11/2018 00:00:00 12251
20/11/2018 00:00:00 12249
21/11/2018 00:00:00 12247
22/11/2018 00:00:00 12245
23/11/2018 00:00:00 12243
24/11/2018 00:00:00 12241
25/11/2018 00:00:00 12239
26/11/2018 00:00:00 12237
27/11/2018 00:00:00 12235
28/11/2018 00:00:00 12233
29/11/2018 00:00:00 12231
30/11/2018 00:00:00 12229
01/12/2018 00:00:00 12227
02/12/2018 00:00:00 12225
03/12/2018 00:00:00 12223
04/12/2018 00:00:00 12221
05/12/2018 00:00:00 12219
06/12/2018 00:00:00 12217
07/12/2018 00:00:00 12215
08/12/2018 00:00:00 12213
09/12/2018 00:00:00 12211
10/12/2018 00:00:00 12209
11/12/2018 00:00:00 12207
12/12/2018 00:00:00 12205
13/12/2018 00:00:00 12203
14/12/2018 00:00:00 12201
15/12/2018 00:00:00 12199
16/12/2018 00:00:00 12197
17/12/2018 00:00:00 12195
18/12/2018 00:00:00 12193
19/12/2018 00:00:00 12191
20/12/2018 00:00:00 12189
21/12/2018 00:00:00 12187
22/12/2018 00:00:00 12185
23/12/2018 00:00:00 12183
24/12/2018 00:00:00 12181
25/12/2018 00:00:00 12179
26/12/2018 00:00:00 12177
27/12/2018 00:00:00 12175
28/12/2018 00:00:00 12173
29/12/2018 00:00:00 12171
30/12/2018 00:00:00 12169
31/12/2018 00:00:00 12167
01/01/2019 00:00:00 12165
02/01/2019 00:00:00 12163
03/01/2019 00:00:00 12161
04/01/2019 00:00:00 12159
05/01/2019 00:00:00 12157
06/01/2019 00:00:00 12155
07/01/2019 00:00:00 12153
08/01/2019 00:00:00 12151
09/01/2019 00:00:00 12149
10/01/2019 00:00:00 12147
11/01/2019 00:00:00 12145
12/01/2019 00:00:00 12143
13/01/2019 00:00:00 12141
14/01/2019 00:00:00 12139
15/01/2019 00:00:00 12137
16/01/2019 00:00:00 12135
17/01/2019 00:00:00 12133
18/01/2019 00:00:00 12131
19/01/2019 00:00:00 12129
20/01/2019 00:00:00 12127
21/01/2019 00:00:00 12125
22/01/2019 00:00:00 12123
23/01/2019 00:00:00 12121
24/01/2019 00:00:00 12119
25/01/2019 00:00:00 12117
26/01/2019 00:00:00 12115
27/01/2019 00:00:00 12113
28/01/2019 00:00:00 12111
29/01/2019 00:00:00 12109
30/01/2019 00:00:00 12107
31/01/2019 00:00:00 12105