Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Expand / Collapse
Author
Message
Posted Tuesday, July 31, 2012 12:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 31, 2012 4:52 AM
Points: 2, Visits: 9
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)


  Post Attachments 
Copy of ActionsTable.xlsx (6 views, 22.09 KB)
Copy of IssuesTable.xlsx (3 views, 14.52 KB)
Post #1337693
Posted Tuesday, July 31, 2012 2:22 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:05 AM
Points: 320, Visits: 1,095
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.)
Post #1337726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse