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

Ya gotta trust me on this one, Ben... things like the following tidbit have been tested, tried, and trued by me and about a thousand other folks on this and...

Koji,

Thanks for posting your solution... THAT's what we like to see when folks get things working!

Heh... know wurrees, Ed... A've bin nown too meke na tyyp-oh hear ond their, meself

Heh... obviously not a "precise" number, eh?

After seeing all the stuff about rounding on these interminable threads, I've decided I'm not rounding anything...

Krissy,

How big are the hard-drives associated with the datafile?  The other question would be, how many months or years does the current 60 gig of space used represent?  The reason...

No...

Each temp table is actually named a bit differently but is transparent to the user... for example, if you have a temp table named #MyHead in a proc, each session...

Ok... first the "party line"   This type of formatting should NOT be done in SQL Server... it should be done in the GUI...

Already posted this on the PM you sent me... thought I'd share the solution I think you are looking for...

CREATE TRIGGER Flag_update

on table_A

for update

as

if Update (Table_A.[Date])

 Begin

  update table_B

  Set Flag =...

Mostly habit, Andy... I heard (a very long time ago) that the sp_OA routines had memory leaks (never did test to find out if that was true, my bad) and got...

Sab,

Would you mind showing us the code you've tried so far, please...

-- Sorry, Jeff. Just to make it repeateble for everyone.

Ack!   I...