meta user
network profile
| bio | website | SeanKilleen.com |
|---|---|---|
| location | Gaithersburg, MD | |
| age | 26 | |
| visits | member for | 1 year, 6 months |
| seen | Apr 11 at 17:25 | |
| stats | profile views | 5 |
I code, I sing, I write, I act. I'm trying to start my own commercial .com site while working a day job as an IT Consultant. Wish me luck, and feel free to help along the way!
|
Apr 2 |
awarded | Popular Question |
|
Nov 16 |
revised |
Should I use SQL or NoSQL for this specific design (surveys)? Added an additional point to adjust to a comment I'd asked. |
|
Nov 16 |
comment |
Should I use SQL or NoSQL for this specific design (surveys)? Thank you, I appreciate the thorough response! Was wondering if you maybe could update it to add your thoughts on an additional concern: with a NoSQL solution (particularly RavenDB), to an extent my objects become my schema and can adjust as necessary. I have to build that in SQL server first (unless I go with Entity Framework). Thoughts on this aspect? |
|
Nov 16 |
asked | Should I use SQL or NoSQL for this specific design (surveys)? |
|
Sep 27 |
comment |
Query missing one date; only happened today Also, If you'd be willing to comment, I'm interested in the speed implications of my answer, because I think it is more readable, though includes a separate union statement. I'm thinking the speed difference should be negligible given the scope. |
|
Sep 27 |
comment |
Query missing one date; only happened today Hi Justin, per my previous answer I also noted that taking the query into account, I decided that there was no way my user could have been running the query as she claimed she was, because it (as you correctly state) would have never returned the current date. Thank you for answering! |
|
Sep 26 |
awarded | Teacher |
|
Sep 26 |
answered | Query missing one date; only happened today |
|
Sep 26 |
asked | Query missing one date; only happened today |
|
Jul 3 |
comment |
Oracle: How do I query a Hierarchical table? Leigh, this was exactly it. Thank you for the help! |
|
Jul 3 |
accepted | Oracle: How do I query a Hierarchical table? |
|
Jul 3 |
awarded | Supporter |
|
Jul 3 |
awarded | Critic |
|
Jul 3 |
comment |
Oracle: How do I query a Hierarchical table? @a_horse_with_no_name logically, I suppose the "building" level would be anything with a parent that is the campus name, i.e. anything with a parent of "MAINCAMPUS". The root of all the nodes is "COMPANYNAME", which is the parent of "MAINCAMPUS", and all buildings (plus "grounds") have MAINCAMPUS as a parent. |
|
Jul 3 |
revised |
Oracle: How do I query a Hierarchical table? clarifying goals and question due to informed responses. Also, language/style edits. |
|
Jul 3 |
comment |
Oracle: How do I query a Hierarchical table? Thanks for the response! I'm getting it enough to realize that I don't think I phrased my question well. My table structure has two columns -- "location" and "parent". The hierarchy these create is defined by my ascii chart. I would like to construct a view that shows, for each location at the "building" level, all locations underneath its branch. My goal is to be able to query a building and get all its sub-locations, or query a sublocation and see which building it belongs to, through a view (so no hard-defined "building-x" in the query). Any help would be greatly appreciated! |
|
Jun 28 |
asked | Oracle: How do I query a Hierarchical table? |
|
Feb 1 |
asked | Oracle SQL for left outer join to rownum = 1 of another query? |
|
Jan 24 |
comment |
Oracle 11g setting for backwards compatibility? I have flagged this question as not a real question as it cannot be reliably answered. The real issue was very far off base from the topic of this question. Thank you to all who attempted to help, but I think it's best that this one goes away for the benefit of the community. |
|
Jan 24 |
awarded | Editor |
