Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

From the answer to my previous question, I found this Data Explorer query:

StackOverflow Rank and Percentile

I put my user_id (897326) and click Run. I get this error:

Arithmetic overflow error converting bigint to data type numeric.
share|improve this question

closed as off topic by ben is uǝq backwards, jonsca, animuson, Toon Krijthe, Bart Nov 4 '12 at 17:15

Questions on Meta Stack Exchange are expected to relate to the software that powers the Stack Exchange network within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

As Siva alludes to below these are user-defined queries and not related to Stack Exchange. If you have a problem with a query that you can't fix, consider asking on Stack Overflow (after first checking that there is no duplicate). – ben is uǝq backwards Nov 4 '12 at 15:56
@Ben In the original version of the question Neolisk was asking whether MSO was the correct place to ask this, and I edited it out, thinking this might have been an issue with SEDE and not the query itself. – Yannis Nov 4 '12 at 16:45
I've corrected the query. I didn't even know people were using it or that so many people had favorited it. It obviously will fail for any user id > 99999. I guess two years ago that didn't seem like such a big deal (and how many of the higher users would have any significant ranking...). – Cade Roux Nov 5 '12 at 0:59
@CadeRoux: thanks for the update. It's amazing how good old things are still being used today. Many examples. :) – user199936 Nov 5 '12 at 1:00
@Neolisk It would be good if we got notifications from SEDE about things that need comments. – Cade Roux Nov 5 '12 at 1:04
@CadeRoux: agree. You can vote on it here:…. – user199936 Nov 5 '12 at 1:07
up vote 4 down vote accepted

You can fork the query by clicking fork query link and then change it according to your needs. In this case, I changed the type casting from CAST(Ranking AS decimal(10, 5)) to CAST(Ranking AS decimal(20, 5)) and the query ran fine for your user id.

Link to the updated query:

StackOverflow Rank and Percentile

Note to the original author:

I have left a comment on one of the SO posts by the original author Cade Roux.

share|improve this answer
Thanks - now it works. But it does not update the original query. So what about those who starred the original query, or various links to it from different part of SO? – user199936 Nov 4 '12 at 15:55
@Neolisk: I have left a comment about this error on one of the posts by the author. – user162697 Nov 4 '12 at 15:58
Looks like pretty much decentralized, meaning you would have to find an author's post on something and comment on that, even if it's not directly related to the problem. – user199936 Nov 4 '12 at 16:00
@Neolisk You may be interested in this feature request: Notify/contact SEDE user of fix to query – Tim Stone Nov 4 '12 at 16:22
Thanks, @Tim - I upvoted and posted a related suggestion in there. – user199936 Nov 4 '12 at 16:31