leea (9/9/2009)
I need something similar, but I need the daily median of a data set, effectively doing a group by on the Date.Only way I've found to do this is with a cursor was wondering if any clever chaps out there have a better idea?
I'm guessing that you're running this against data that is historically static, correct? If so, how about creating a table to hold the results of your daily median calculation? That way you don't have to rerun it for historic data every time a user needs it.