on 09-14-2012 9:44 AM
We have a requirement of fetching reports for user skills matrix.
In this we have 5 drop downs for selecting the criteria.
If we look at these, there are numerous combinations for fetching the data, which is not good coding standards.
If you can suggest me a better logic for fetching the data!!!
You will find the screenshot attached of the selection screen!!
Hi,
Convert it to range table and use IN in select query.
This will help u.,
Regards,
Kiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.