Answered by:
find requests, that had been solved in a 5 hours

Question
-
Hello, I newbie in Microsoft Visual Studio 2008.
I have a SQL query, which shows a time that had been spendeed on solving each request by every employee. Data base is Microsoft SQL Server on
Windows Server 2008.
I want to find requests, that had been solved in a 5 hours and above from table 1.
How should i change a table 1 using Report Designer в Microsoft Visual Studio 2008, in order to get a table 2:
table 1
employee, number of a request, a time that had been spendeed on solving each request (hour)
USER1,001,6
USER1,002,5
USER1,003,4
USER1,003,3
USER2,004,5
USER2,005,2
table 2
employee, number of a request, a time that had been spendeed on solving each request (hour)
USER1,001,6
USER1,002,5
USER2,004,5
- Edited by Aleks Roth Saturday, October 15, 2016 1:14 PM Hello, I newbie in Microsoft Visual Studio 2008.
- Moved by Oscar_Wu Monday, October 17, 2016 3:15 AM related to SQL
Saturday, October 15, 2016 1:06 PM
Answers
-
Hi Aleks Roth,
You could simply add WHERE clause to your existing SQL query or Add a Filter to a Dataset.
Sam Zha
TechNet Community Support- Proposed as answer by Riaon Monday, October 17, 2016 7:43 AM
- Marked as answer by Sam ZhaMicrosoft contingent staff Friday, October 21, 2016 10:50 AM
Monday, October 17, 2016 6:05 AM -
Sounds like this to me
SELECT * FROM [table 1] WHERE timespend >= 5
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page- Marked as answer by Sam ZhaMicrosoft contingent staff Friday, October 21, 2016 10:50 AM
Monday, October 17, 2016 6:42 AM
All replies
-
Hi Aleks Roth,
This forum is discussing Visual Studio WPF/SL Designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System, and Visual Studio Editor.
Your issue may be related to SQL development I will move this thread to corresponding forum for a professional answer.
Sincerely,
Oscar
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey.
Monday, October 17, 2016 3:12 AM -
Hi Aleks Roth,
You could simply add WHERE clause to your existing SQL query or Add a Filter to a Dataset.
Sam Zha
TechNet Community Support- Proposed as answer by Riaon Monday, October 17, 2016 7:43 AM
- Marked as answer by Sam ZhaMicrosoft contingent staff Friday, October 21, 2016 10:50 AM
Monday, October 17, 2016 6:05 AM -
Sounds like this to me
SELECT * FROM [table 1] WHERE timespend >= 5
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page- Marked as answer by Sam ZhaMicrosoft contingent staff Friday, October 21, 2016 10:50 AM
Monday, October 17, 2016 6:42 AM