Hi, I'm using tAdoDataSet to query data from my sql server. It's working fine but now I wan't to do something more complex and I need to query the results like access would do.
For exemple, I'm compiling all invoices in a query. Next I wan't to sum for each customer the total amount invoiced (from my query result).
I could probably do this in one query but I need to make some complex filtering on things like groups, category and prices and I have found that it's really much slower using a where condition vs a having condition (which I must use if I'm grouping to create a sum).