Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Selecting distinct/non distinct from same data set

Posted on 2012-04-12
5
470 Views
Last Modified: 2012-06-27
Hello. In a call center environment, each call that comes in is placed into an appropriate category. Calls are placed by participants.

The goal is to count how many times the same participant called into the same category within a 15 day period. Those records need to be tabulated, other calcs remain, but this is the hard part.

See attached file for 2 queries. Only difference is that one is distinct, the other is not selecting distinct. If I could somehow subtract the counts from eachother i would get at the needed number. But because it has to be summed as a group with participant, I'm not sure how these could be subtracted. Maybe a sub-select query of some sort?

Thanks for any advice.
0
Comment
Question by:dprasad
  • 3
5 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 37839569
no queries were attached, but that's ok, don't really need them

please post sample data and expected output
0
 

Author Comment

by:dprasad
ID: 37839717
Doh, please see it attached and i think you will understand my method..
queries.txt
0
 
LVL 20

Accepted Solution

by:
flow01 earned 500 total points
ID: 37840239
as far as i can see you can combine them

select COUNT(V_CATEGORY.PKEY) AS CATEGORY_COUNT,
       COUNT(distinct V_CATEGORY.PKEY) AS DCATEGORY_COUNT,
       COUNT(V_CATEGORY.PKEY) - COUNT(distinct V_CATEGORY.PKEY) DIF_COUNT,
       V_PARTICIPANT.PKEY AS PART_KEY
FROM
..
0
 

Author Comment

by:dprasad
ID: 37842279
Thanks!!
0
 

Author Closing Comment

by:dprasad
ID: 37842286
thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL replication over high latency link 10 52
Row_number in SQL 6 33
physical_device_name field in SQL 3 30
format dd/mm/yyyy parameter 16 28
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question