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

Answer 1

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.

Answer 2

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

Answer 3

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