The query tag has no wiki summary.
10
votes
8answers
795 views
How do I make complex SQL queries easier to write?
I'm finding it very difficult to write complex SQL queries involving joins across many (at least 3-4) tables and involving several nested conditions. The queries I'm being asked to write are easily ...
1
vote
2answers
168 views
Designing complex query builders in java/jpa/hibernate
I need to build complex sql queries programatically, based on large filter conditions.
For example, below are few sample/hypothitical filter conditions, based on which i need to fetch users
Country: ...
0
votes
0answers
27 views
Using QTIP2 in COGNOS “content” customization
I'd like to know how to call to a query in COGNOS 8 using qtip2. Where do I plugin the required "content?"
For instance: ajax was calling to a wiki server that pulled an image and content ...
1
vote
1answer
77 views
“t-sql” tool for csv files?
Is there a tool that allows to query files based on the following criteria, and change them?
creation date
filenames (e.g. filetypeA_YYYYMMDD_data2.blah)
file content
For the example, the workflow ...
0
votes
1answer
24 views
Users and roles: Where to put queryUsersWithRole()?
I have two model classes User and Role and two managers/DAOs (UserManager and RoleManager) plus a method which gives me all users with a certain role (List<User> getUsersWithRole(Role)).
In ...
2
votes
1answer
198 views
Querying key/value store
I don't know whether this question is reasonably answerable (and therefore will be closed), but I will take my chances: What are the possible problems (and solutions), one might encounter, when ...
2
votes
1answer
53 views
Best design for a memory resident tool
I apologize if this tends more toward design that programming, but here goes.
What design would you recommend for a database that is
Memory resident
Must run on windows, linux and (at a stretch) ...
24
votes
12answers
883 views
Why don't relational databases support returning information in a nested format?
Suppose I'm building a blog that I want to have posts and comments. So I create two tables, a 'posts' table with an autoincrementing integer 'id' column, and a 'comments' table that has a foreign key ...
37
votes
12answers
2k views
Should experienced programmers know database queries?
There are so many programmers out there who are also an expert at Query writing and Database design.
Should this be a core requirement to be an expert programmer or software engineer?
Though there ...
