locked
find requests, that had been solved in a 5 hours RRS feed

  • 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

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

    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

    Monday, October 17, 2016 6:42 AM