The dam broke in my brain when ratbak said "mapping table". I made a temporary crosstab table mapping the 3ltrcodes to the comment codes.  Thank you.

What I'm actually doing is more complicated than what I posted. I just wanted the quick answer -- Can you do this? Yes/no. Seems the answer is "no". But since...

Oh, I think you mean the comment by Joe Celko about your low score etc.

Yes, I meant that. I really can't believe I reached out for help and was personally...

Wow! I put out a quick question before I need to go in for an MRI and I come back to find this comment. That is really rude. Thank you...

• This reply was modified 3 years ago by  amyfgehring.

Thank you for the reply. The rows are linked, but I wouldn't necessarily say there is a child / parent relationship. As in there are children, but I'm not sure...

No worries, Ken. I figured it out. Stay safe!

Ken,

I like this solution. My big question is once you have a list of select statements in your results, how do you execute them? I can look it up if...

My coworker is a big believer in WITH (NOLOCK) and insisted I put them in every query. I'll have to tell him what you said.

Anyway, I have made some progress....

Thank you very much Thom. That was exactly what I was looking for.

In the download that accompanies this article

Did I miss this?

Thank you for replying, Sue. I have really wasted the whole day on this. On the plus side, I've learned a bit about javascript and style sheets. I have managed...