8

The dba thread in question: Access (Jet) SQL: DateTime stamps in TableB flanking each DateTime stamp in TableA

I believe with the status of my code as it now stands, my question may be better suited for CR than it is for DBA. Should I request that it be migrated? Should I cross-post this meta question over on meta.CR (but obviously not cross-post the base question itself on CR proper)?

When I initially asked my question yesterday, my base code was not fully developed and had a couple of minor bugs, which "disqualified" it from consideration over at CR. I believe those have since been addressed (but I defer to your better judgement).

mpag a.k.a. today's StackExchange newbie

Relevant topics that addressed this generally, but not my case specifically:

  1. Which site is best for code reviews of queries?
  2. Overlap between codereview and dba
  3. Recommendation: Beginner needs to Regularly Post SQL Code for Troubleshooting. Where to?
  4. Is MS Access on-topic?
12

Your question is on-topic here and would also be on-topic for Code Review (I checked with a moderator from that site to be sure).

We do not have many active Access experts here on dba.se, so a high proportion of questions unfortunately currently go unanswered. Code Review has a much better record in that respect, but that may simply reflect the low number of Access questions there (22).

Even so, on balance, I suggest you leave this question where it is for a couple of days at least. If it still has a low number of views and no answers after that time, we can look at migrating* it, or other ways to attract attention.

The question would benefit from including table and index definitions wherever it ends up. Also, be sure to add clarifications to the question body rather than in comments.

* If we do migrate it, we will almost certainly close/delete it here.

8

Your question would be on-topic on Code Review. However, it is also on-topic for DBA. By Stack Exchange policy, being a better fit on another site does not make it eligible for migration; only questions that are off-topic on the original site may be migrated. (Many questions are asked every day that could conceivably fit on more than one site. That rule exists for a good reason.)

If you don't get a satisfactory answer here after waiting a reasonable amount of time, you are welcome to cross-post your question. Be sure to declare your cross-post with mutual links as comments, to avoid wasting other people's time.


In my experience answering questions on Code Review, I've found reviews of complex SQL queries to be some of the most time-consuming questions. You really have to understand every part of the query before you even begin to formulate a response, and in many cases it is necessary to rewrite the monster query from scratch using a completely different strategy. (Example 1, 2) You can make your question more attractive by making it as easy as possible to review your code.

  • Provide the table definitions of all relations involved, so that reviewers don't have to derive them by reverse-engineering your query.
  • Mention all constraints, keys, and indexes.
  • Provide sample data and the expected result set.
  • Include an executable demo as an SQL Fiddle. I realize that SQL Fiddle doesn't support MS Access, but it looks like another database like MySQL could be a close enough substitute for demonstration purposes.
  • I provided an English explanation of the keys, but I can definitely see how my question would be aided by at least a pseudo-coded list of keys, foreign key constraints and indexes. Thank you for suggesting the fiddle method as well. – mpag Oct 1 '15 at 19:18
  • added table defs to the post (and rearranged it) – mpag Oct 2 '15 at 18:43
  • I was thinking of posting on CodeReview's meta page to raise attention. However a) I don't have the rep to post on the meta there b) I don't want to make a "question" on the main CR page, as this thread already has enough momentum to keep it. If you believe it appropriate, could you post a "question" on the meta there and reference the bounty here? :) – mpag Oct 9 '15 at 20:15
  • 1
    I've publicized it already in our chat room. I'll do it again now. – 200_success Oct 9 '15 at 20:27

You must log in to answer this question.

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