That is representative of one of the conditions. I am not sure how I am going to populate the null columns from one of the duplicate rows. I...

Yes that worked. Thanks to all of you. It took me some study to understand what he did but i got it.

These are all reasonable questions Jeff. Here is what is going on in my case and it may be similar conditions for other people that have made a similar...

I do not know CTS. I will have to do some study.

Gee.. thanks Prof. LOL I an sure i will be back with questions on CTE.

Got it 🙂 You have really added to my knowledge base and tool bag.

Thank you very much!

There is a primary key in the table, MyTableID. Your description if the ways to do this is very good. I am learing a lot. How would the...

JeffB –

The requester did not care which row was returned. All of ColX was populated. He just wanted a value from ColX.

Matt –

You have blown past...

GSquared

I understand your explanation. Makes perfect sense. The problem I have had when working with DISTINCT is that all columns in the select list are engaged in the distinct....

I am new to MS SQL and am trying to learn how things should be done. Given there are many ways to do the samne thing.

The solution you suggest...

That is interesting. I'll play around with it.

Took a little study for me to understand what you did but i get it. 🙂 Thanks.

Good point.

This remindes me of a related question i have had. How to return additional fields that are not in the DISTINCT field list?

If I have data that looks...

I see. Missed when i first read it. thanks

Great solution. Much simpler. Thank you