I get blocked because my questions have been closed several times without a clear reason for closing them. Why were my questions closed?

First question asked (now closed and deleted)

Second question asked (now closed and deleted)

Third question (now deleted)

  • 13
    Do you mean your question is on hold (which it is) or that you are blocked from asking more questions – Richard Tingle Mar 26 '14 at 11:38
  • 6
    Please, take some time to read the help center. It will clarify the on-hold process and help improve your questions, so you'll receive answers and upvotes (instead of downvotes and question closure). – brasofilo Mar 26 '14 at 11:50
  • 3
    Your original question had Excel and VBA in the title and in the tags. Were you trying to get the data in that format in MySQL? In Excel? Did you need help with VBA? It was unclear, and since you didn't give any example of a query or an Excel formula or anything else, I voted to close the question. Your second question was basically the same, but with a bunch of (imho) irrelevant info added. I still didn't know what you were trying to do. Perhaps I should have left a comment to explain what exactly was wrong with your question. – Stijn Mar 26 '14 at 12:25
  • 3
    I see closing and voting on questions as ways to make sure stackoverflow is a collection of questions with good answers. When I ran into your first (now deleted) question it didn't include enough or was clear enough to be answered. Your second question (btw: you should have updated/edited your first question, but that is a different topic) is improved a little bit but still has issues as pointed out by Richard. So I felt a vote to put your question on hold again appropiate. With regard to the comment you left on your question: I'm not easily offended, others might be. – rene Mar 26 '14 at 12:26
  • The third question is a copy-paste repost of the first. That's not good. – jscs Mar 26 '14 at 18:42
  • A question following this one should be why do we allow that... 3 questions , 2 closed, 3rd gets answered... so 10 people have wasted their 10 votes and time to do moderation but in the end the poor OP gets his answer anyway.. – user221081 Mar 27 '14 at 8:40

Ask a question

In your now on hold question you never seem to actually ask a question.

After a bit of reading I figured out the implicit question; that you wanted the data to output as per the last table, but it was coming out like the one to last table. Describing what you're doing is useful, but it's easier to understand if you also ask an explicit question.

Make your question as simple as possible

You seem to have a lot of extraneous information, 4 tables of data, each with many columns, provided as images. I'm sure that’s the real situation you're dealing with but is it really necessary for the question? Try to reduce it down to the bare minimum that replicates the problem; then the question will be far clearer.

Your simpler version

You created a simpler version here (ideally edit the existing question rather than reposting a new version), this suffers from the opposite problem; it isn't clear what you're stuggling with without seeing an attempt. Ideally try to find some middle ground between the two, the simplicity of this version with the attempted solution of the more complicated version.

It would be better to have really simple source data (2 tables, 2-3 columns each), the sql you use to try to get the output. An example of the output, and whats wrong with that output.

However, while not ideal this version is at least clearer and seems to be attracting answers

| improve this answer | |
  • 3
    And it's clear to see that this user didn't read any of the topics in the help center on how to ask a question – CodingIntrigue Mar 26 '14 at 11:48
  • Richard Tingle, thank you so much for your reply, the problem is that yesterday I asked this same question in a simple way, where I provided my code and example of the current output and the output i would want, but this crew blocked me, telling me that I am not making any effort to solve the issue. I am not a professional in programming sql, that is why i need help. Lots of people provide similar questions and they get answers, but when this crew comes in they just block anyone and vote negative on people. This is the place for people to seek help. – user3458635 Mar 26 '14 at 11:55
  • @user3458635 I can't see the now deleted version so can't comment specifically. However, the best questions simplify the problem and show your attempt to solve that simplified problem and how it didn't work – Richard Tingle Mar 26 '14 at 11:57
  • At the end of the question I gave an example without any image where the output is not what i want and i made an example of the output I would like. Also I said that I used pivot but still didn't get the desired results. I also stated that I might be wrong somewhere and would want some help. Isn't it fair enough? – user3458635 Mar 26 '14 at 11:58
  • Yes I deleted it today in the morning – user3458635 Mar 26 '14 at 11:58
  • @user3458635 As I say, without seeing the specific question it would be pure speculation on my part – Richard Tingle Mar 26 '14 at 11:59
  • @user3458635 I've edited my answer, but basically thats too far the other way. Better to have really simple source data (2 tables, 3 columns each), the sql you use to try to get the output. An example of the output, and whats wrong with that output – Richard Tingle Mar 26 '14 at 12:05
  • the example of the output is what I wrote first and what i want to achieve is what i wrote in the second example. The problem is, I can't have it done the other way, because these tables are from Opencart. We have an online store, where we want to manipulate data. But it is not comfortable to edit data with product_id repeated 3 times. We have over 14000 products, I don't want the product_id to be repeated 3 times each, because that will make 42000 rows of data – user3458635 Mar 26 '14 at 12:11
  • Simply I want the rows to be broken into columns as in the example – user3458635 Mar 26 '14 at 12:11
  • 2
    @user3458635 I see you have your answer so the question is somewhat mute but to better explain what I mean: Say I have a huge program that should ultimately outputs Hèllo but instead outputs H#llo then posting the entire program is unlikely to get me an answer. However; if instead I simplify the program, removing pieces, and removing pieces and seeing if the problem remains I will ultimately end up with a really small program that replicates the problem but is much easier to understand. If I post that; I will likely get my answer. – Richard Tingle Mar 26 '14 at 12:23
  • 6
    mehow is doing a service for Stack Oveflow users, using the tools available to him, @user3458635. Easy with the abuse. – Michael Petrotta Mar 26 '14 at 12:53
  • 9
    Richard and @mehow have done some cool work helping here, for sure. Kudos to them both. – Andrew Barber Mar 26 '14 at 12:56
  • 6
    @user3458635 great, you've made my day ;) – user221081 Mar 26 '14 at 13:13
  • 1
    The situation has been resolved, seemingly to the benefit of all. I think it’s time to call it a day now – Richard Tingle Mar 26 '14 at 13:14

Not the answer you're looking for? Browse other questions tagged .