Post reply

tsql code

  • July 6, 2012 at 10:12 pm

    #263486

    Imagine a table which contains records for all weekly number of bugs

    discovered by each QA analysts in the team for one year. Please describe a

    simple SQL statement for identifying a winner (an employee who found the

    biggest number of bugs during that year) by writing one statement?

  • July 7, 2012 at 1:36 am

    #1509951

    debris_flow (7/6/2012)

    Imagine a table which contains records for all weekly number of bugs

    discovered by each QA analysts in the team for one year. Please describe a

    simple SQL statement for identifying a winner (an employee who found the

    biggest number of bugs during that year) by writing one statement?

    This is a simple exercise made difficult by having to imagine what the table and data look like. Read the link in my sig "please read this" and provide DDL for the table and DML for some sample data.

    Otherwise you may have to imagine what the simple SQL statement might look like 😉

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • July 7, 2012 at 7:31 am

    #1509962

    Thank you very much for your suggestion

  • July 7, 2012 at 1:15 pm

    #1510012

    debris_flow (7/6/2012)

    Imagine a table which contains records for all weekly number of bugs

    discovered by each QA analysts in the team for one year. Please describe a

    simple SQL statement for identifying a winner (an employee who found the

    biggest number of bugs during that year) by writing one statement?

    This is a terrible homework problem. 😛 It doesn't tell you what to do if there's a tie. 😉

    Some hints to solve this (and there are many different ways). Lookup the following in Books Online.

    GROUP BY

    SUM()

    MAX()

    ORDER BY

    COMMON TABLE EXPRESSIONS (CTEs)

    RANK()/DENSERANK()

    ROW_NUMBER()

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply