Virginal
04-06-2012, 01:06 PM
I have a dataset with a large number of rows. I sort this by Shop, Sales Person, DateTime Last Sale.
I now want to find the most recent "date/time last sale" for each shop, the obvious thing seems to do a pre sort but that seems like using a sledgehammer to crack a nut.
I want to use the quickest way to find those dates and maybe doing the sort is not so resource hungry as I think.
All opinions welcome
I now want to find the most recent "date/time last sale" for each shop, the obvious thing seems to do a pre sort but that seems like using a sledgehammer to crack a nut.
I want to use the quickest way to find those dates and maybe doing the sort is not so resource hungry as I think.
All opinions welcome