Need SQL Query for fetching Results from QC
- Thread starter ngtb07
- Start date
spikepl
Eledittingent Beliped
- Local time
- Today, 17:10
- Joined
- Nov 3, 2010
- Messages
- 6,142
1. Please do not double post questions (http://www.access-programmers.co.uk/forums/showthread.php?t=224037)
2. You need to do some homework and supply some more specific information, otherwise how can we guess what your specific problem is.
SQL query to fetch WHAT exactly from WHERE exactly using WHICH exact conditions?
As to exporting data to Excel do a search on this forum using the forum Search, or Google - there is thousands of posts on exporting data to excel.
2. You need to do some homework and supply some more specific information, otherwise how can we guess what your specific problem is.
SQL query to fetch WHAT exactly from WHERE exactly using WHICH exact conditions?
As to exporting data to Excel do a search on this forum using the forum Search, or Google - there is thousands of posts on exporting data to excel.
Hi,
thanks for reply. My question was pretty simple if u did not understand then dont know why. My question was, need SQL query for Quality center which we will write in Dashboard of Quality center. This query will fetch all requirements of project. so in this case Select will be *, from will be REQ table and where will be Project name. And I have to make it globally so that whoever execute this query he/she will get all requirements of his/her projects.
Thanks.
thanks for reply. My question was pretty simple if u did not understand then dont know why. My question was, need SQL query for Quality center which we will write in Dashboard of Quality center. This query will fetch all requirements of project. so in this case Select will be *, from will be REQ table and where will be Project name. And I have to make it globally so that whoever execute this query he/she will get all requirements of his/her projects.
Thanks.
It's extremely rude to insult someone's intelligence when they are trying to HELP YOU.
On top of that, Spike is right. Your question was nearly unintelligible for two reasons:
1) How are we supposed to know what "Requirements from QC" and "test cases" are?
2) You didn't ask for any advice, you're just asking for someone to do the work for you for free.
When you ask for help, it is best to use GENERAL terms like:
"How do I create a Query and Export it to Excel?"
We don't work with you so we don't know what kind of data you're working with or what you're trying to accomplish. Even in your more detailed response I have absolutely no clue what you're asking us to do for you. Do you have a question about something or are you just letting us know what you've got going on? Don't expect an answer if you don't actually ask a question.
Good luck finding help.
MSAccessRookie
AWF VIP
- Local time
- Today, 11:10
- Joined
- May 2, 2008
- Messages
- 3,428
There is no need to feel bad.
As spikepl and GregRun pointed out, we need more detailed information. For instance, We are not aware of your system, and as such do not know what you mean by "fetch Requirements from QC only", nor can we be sure how to identify "any test cases". Saving the results in Excel usually uses standard methods.
Information like Table Structures and SQL Query Texts are always helpful, as well as the specific text of any error messages that are present.
Please feel free to post back and we will try to help.
