July 31, 2012 at 3:16 am
i have two tables 1) issue and 2) actions.
in Action table i have employeename(ramabai) and employeeid(4402) and ISSUEID(521779) which common in both the table.
Now i want to see Number of complaints closed by the employee & not reopened(Field name is status in issues table) and status for closed is '4' and not reopened is '5' how to hit query in sql. please help
July 31, 2012 at 3:39 am
Duplicate question. Original thread can be found here:
http://qa.sqlservercentral.com/Forums/Topic1337693-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2012 at 3:44 am
If there's 1 issue, presumably the complaints refer to the 1 issue. How are the complaints shown in the database?
Does status=5 mean 'Reopened' rather than 'Not Reopened'?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply