I kind-of see what you did with that. You split my inner-most 'union all' query into two parts. The top with 5 case statements totaling sums and 'unioned'...

Sorry I'm not the best at describing.

The "colA" I keep joining the table on itself is unique and I treat it as the 'primary key'. It would be easier...

Thanks for the help guys. I'm sorry it was so simple, and that simplicity took me so long to find.

Do I mark this thread as 'resolved' somehow?

Thanks Jeff.

The problem is my test code must not adequately reflect the issue I'm having. My issue is still separating the 'sums' as I posted just prior to your...

Lutz,

Thank you. However, when I tried this before, it counts the distinct numbers in colB as 1 group and does not add them to the others for the same...

Don't mistake the word hacker, if that's the problem. I'm certain of what I said. I cannot create or delete or update or do any administrator function in...

No I do not have rights to create a table. I'm a pharmacist working at a hospital. I only have access to our health care operating systems database...

Well this is my first time ever, and I'm looking at someone else's code. But, just for you Jeff!

create table tab(

colA varchar(7),

colB int)

go

insert into tab(colA,colB)

select 'aaa','2' union all

select 'aaa','3'...

Thanks guys. I looked at those suggestions for a good while trying different things, but couldn't figure out how to utilize them quite like I hoped. I spent...

@mister.magoo- TY sir, this style query worked well for my current needs and is simple enough for me to wrap my head around after thinking about what it is saying...

OK, I'm getting closer, but still need help. Here's what I have:

select DrugID,InventoryID

from DPhaDrugInventories a

where exists (select distinct b.DrugID from DPhaDrugInventories b where a.DrugID = b.DrugID

and b.InventoryID =...

My bad. You are correct in that my description is lackluster. The exact definition of what I need hasn't come to my attention yet, which is why I'm...

You da man. That worked really great except I didn't explain enough of what I needed. Here's what I have:

select a.DrugID,a.InventoryID from DPhaDrugInventories a

where exists (select * from...

Ya a BSPharm is a bachelors and the PharmD is a doctorate. Actually, since 2003 or so there are only PharmD degrees available, the BS has gone by the...

Thanks Rich. How did you know I was a PharmD and not BS-Pharm? I appreciate your comment, it made me smile.

I hope to someday get a good position...