• 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

    😎