This post shouldn't have been closed as a dupe or deleted since it's fundamentally different that the supposed original. The moderators unlocked it for me so it could be voted on, I hope any Meta 10ks here can check it out to see if they think it worthy of an undelete vote.
We currently have five standard close reasons network wide:
This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question.
Questions on Stack Overflow are expected to generally rela...
When a question is closed as a duplicate, the duplicate question is selected (by the users who vote to close) and then a link to it is attached automatically to the top of the message as a blockquote.
Part of the site design at English.SE includes a style for blockquotes that emphasizes their "...
I guess I can't use a calculated column in another calculated column in SQL? :/
p.OwnerUserId as [User Link],
u.Reputation, COUNT(*) as "Question upvotes",
u.Reputation - (count(*) - 400)*5 as "New reputation",
"New Reputation"/u.Reputation as "% loss"
Invalid column name 'New Reputation'.
p.OwnerUserId as [User Link],
SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) as "Question upvotes",
SUM(CASE WHEN PostTypeId = 2 THEN 1 ELSE 0 END) as "Answers upvotes",
SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END)*1000/COUNT(*) as "Question upvotes ‰"
from Votes p2v
join Posts p on p2v.PostId = p.Id
join Users u on p.OwnerUserId = u.Id
p2v.VoteTypeId = 2 and
p.CommunityOwnedDate is null and
p.OwnerUserId is not null
group by p.OwnerUserId, u.reputation
having COUNT(*) > 100 and
This does what I want but it's just plain ugly
it's ugly that I have to group by reputation to select it, it's ugly that I have to repeat those SUM's so many times, that double nested CASE is ugly....
Hello I have a boolean problem.
I have to make my boolean a global variable for it to work but it need to to be local so I can make many Doughnuts. The boolean when set to true disapears as it has been "eaten" when false it has not been eaten.
The problem with setting it global is all my doughn...
Could we put a cap on reputation earned by asking questions?
I am starting to wonder if we should cap reputation gained for questions.
I have historically resisted this, but:
It does seem nonsensical that users can get 10,000+ reputation purely on the basis of asking hundreds of qu...
I propose that after a certain amount of time has passed since the last edit on a question or post, that all links within that post should no longer be flagged with rel="nofollow". Here is my reasoning:
The web is built on creating meaningful links. There are literally hundreds of thousands of ...
@badpssockpuppet > to prevent gaming of this feature the details will remain a bit vague for the moment. We will be reviewing posts that meet the criteria and tweaking - but the goal is as stated below: to give credible and relevant links the attention they deserve. – Geoff Dalgas
@badpssockpuppet You can haz ogv, since I don't have an account on the YouTubez for some reason. Also interesting to note, Chrome tries to play that file and pretty much freezes up the tab, good stuff.
I had three posts, that were valid when written, deleted today, because someone thought they no longer belonged. They may be right on some of them, that they aren't valid anymore (they refer to Stack Exchange 1.0), but that doesn't mean I should lose the rep and badges for them.
My request woul...
This is another case of Stack Overflowism; since something is broken for the 0.0001% of the population on Stack Overflow, we must bend the rules everywhere and make the reputation system "even more complex" (complaint Jeff threw in my general direction in reply of an unrelated suggestion, see cha...
This question exists because it has
historical significance, but it is not
considered a good, on-topic question
for this site, so please do not use it
as evidence that you can ask similar
More info: http://stackoverflow.com/faq
Nobody likes waiting but unfort...
People constantly ask how to parse a block of HTML using a regular expression.
A popular response is simply "you can't". Is that an appropriate answer on its own?
A few recent examples:
4366057 - This was the leading answer until I've posted a link on the PHP chat room, asking for better answe...
Don't listen to these guys. You actually can parse context-free grammars with regex, but you first need to solve the halting problem. After that it's pretty trivial - you just need an algorithm to losslessly compress random data, work out the Traveling Salesman Problem in O(log n), and divide the...