Paul Giles-Randall (7/25/2016)
Firstly, this is a system that I have inherited.I have a cursor that pulls out a set of ids and amounts. The data is as follows:
ID | Amount | Status
-----------------------------------------
1 | 15.00 | Paid
2 | 3.00 | Paid
3 | 10.00 | Awaiting
4 | 12.00 | Awaiting
Quick questions, how large is your data set?
a) Distinct count of IDs
b) Number of transactions in total
c) Number of periods
😎