Heh... thanks for the nice compliment, but I'm just another Homer like everyone else... sometimes I can make things work ... sometimes not...

Neat trick, Peter... I've got a couple of places where that's gonna come in handy!

Adam,

Are you all set have Remi's suggestion or are you still having problems?

THAT's one of the things I like about you, ALZDBA!!  Need more folks that can come back and say "Dang, made a mistake".  Rare breed indeed

Oh heck yeah!  Sorry Cory... I forgot about that!   I remembered the fax but forgot the message

ISFA = "In So Far As" if that's what you meant by "WTF does that mean?"... or did you have a different question, Cory?

Dunno where you came up with "PC...

Any chance that table 2 could have new rows in it that aren't in table 1, yet?

Heh... using a tool like Query Builder is great for certain tasks... but, I...

Everytime I think of any type of rounding ISFA money is concerned, I keep thinking of that wonderfully silly movie called "Office Space"... if you haven't seen it, go rent...

Adam...

What do you want to happen if the amount of data exceeds the VARCHAR(250) column you've outlined?

Simply stated... YES... that's exactly the way to do it.  As Serqiy pointed out, there are some performance issues that will resolve AND there are other benefits down the line, as well.

There are...

Sure... it's definitely a trick... we needed some way to aggragate all of the "findings" to a single row for each ID/name.  We also needed the some aggragate to wrap the...

Or, in your terms, Denby...

 SELECT pd.KPAIDS_NO, pd.LastName,pd.FirstName,

        MAX(CASE WHEN dl.Clinical_Diagnosis LIKE 'Lymphadenopathy%' THEN 'Yes' END) AS Lymphadenopathy,

        MAX(CASE WHEN dl.Clinical_Diagnosis LIKE 'Candidiasis%'     THEN 'Yes' END) AS Candidiasis,

        MAX(CASE...

This exact same problem has appeared a couple of times now... starting to look a lot like homework... please post the code you've tried and then we'll help you figure...

Jin is correct... if you want multiple variable returns, one of the preferred mthods is to us sp_ExecuteSQL...  and Books Online is the place to learn how to do that.

Heh!  Now THAT's useful info!   You just talked me into putting nice sharp metal edges on it