SQL

  • I have two sql table Actions and Issues:

    i require which query will execute following questions.

    1. Number of complaints attended by the employee

    2. Total number of hits by the employee on these complaints (since

    there may be multiple attendances to theses complaints by the

    employee)

    3. Number of complaints closed by the employee & not reopened

    4. Number of complaints closed by employee and reopened.... but

    finally closed by another employee

    Hints:

    3. Status enum values in action table

    > 1 THEN 'UnAssigned'

    > 2 THEN 'New'

    > 3 THEN 'Pending'

    > 4 THEN 'Closed'

    > 5 THEN 'ReOpened'

    > 6 THEN 'UnAttended'

    Period: April 2011- March 2012

    > For Employee: 531470

    M LAXMI BAI (531470)

  • You're more likely to get an answer if you make the data easy to set up.

    See this thread, post 6 for a way to do it:

    http://www.sqlservercentral.com/Forums/Topic1336553-392-1.aspx

    (There's an article in the post footer too.)

Viewing 2 posts - 1 through 1 (of 1 total)

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