•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,766 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,185 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 546 | Replies: 2
 |
•
•
Join Date: Nov 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Need help to build a query I'm having trouble with the following scenario:
drivers may have any of the 16 types of certificates, tasks may require any of the 16 types as well. What I need to do is build a query that will selectd all the tasks a certain driver can perform.
Example:
driver has these certificates: A,B,C,C1,C1E
so he can perform tasks that require any of these certs or any combination of certs (ie. only A, only B, both A and B, A and C1E, A,B and C1 etc).
I already have come up with a solution (which makes every possible combination), but it is very complicated and works well only with a smaller number of certificates, but with 16 (as it is the case) it requires more memory then it is available...
Any idea how to make a more efficient query?
Thanks for the time
drivers may have any of the 16 types of certificates, tasks may require any of the 16 types as well. What I need to do is build a query that will selectd all the tasks a certain driver can perform.
Example:
driver has these certificates: A,B,C,C1,C1E
so he can perform tasks that require any of these certs or any combination of certs (ie. only A, only B, both A and B, A and C1E, A,B and C1 etc).
I already have come up with a solution (which makes every possible combination), but it is very complicated and works well only with a smaller number of certificates, but with 16 (as it is the case) it requires more memory then it is available...
Any idea how to make a more efficient query?
Thanks for the time
Last edited by veggen : Nov 15th, 2007 at 12:27 pm.
•
•
Join Date: Aug 2005
Posts: 4,663
Reputation:
Rep Power: 16
Solved Threads: 297
You would have to go for a 'dynamic solution' where you are not guaranteed to hit the optimal solution.
A good example would be Dijkstra's shortest path finding algo.
A good example would be Dijkstra's shortest path finding algo.
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- storing a query for later use (PHP)
- Multiple queries within one php file (PHP)
- VB and Excel. (Visual Basic 4 / 5 / 6)
- Date functions (PHP)
- dynamic tables (ASP.NET)
- Issue with the LIKE expression and php (PHP)
- Please Help!!! MOD function (ASP)
- parsing csv file (PHP)
- IO and Embedded SQL (Java)
Other Threads in the MS SQL Forum
- Previous Thread: What is the Commonent that must Instal in my Installer
- Next Thread: SMIL files
