July 31, 2012 at 12:56 am
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)
July 31, 2012 at 2:22 am
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