I'm wondering what the query is to calculate reputation. I know how to select the individual components of reputation but it seems pretty difficult to put them all together in one query...
Are there any examples out there that show this?
I'm just taking a wild stab at this since I don't really know anything, but it would seem that calculating reputation is an algorithm that can't easily be expressed as a
It involves many conditions that not only work on rows but on spans of rows within the set of data corresponding to your activity. For example, identical rows have to be treated differently depending on whether their timestamp is before or after you hit the reputation cap on a date, which itself is defined by the same set of rows.
Of course it's possible to do in SQL, just like it's possible to write Microsoft Word by hand in machine code, but it may be a situation where it's not worth the time to write such a complex thing when it's more easily expressed in other ways.
http://stackoverflow.com/reputation gives you the breakdown without having to write a query if you just want to verify the components that went into your total.