Solved

Selecting distinct/non distinct from same data set

Posted on 2012-04-12
5
472 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
[X]
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
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
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 shows how to recover a database from a user managed backup

726 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