Works like a champ. Thank you very much for your assistance !!!

Based on your example, I moved the XML part into the CTE like this:

[code...

Thank you Luis and Chris. I think this should work and I appreciate your assistance. This site is full of knowledgeable
and helpful people !!

If anyone...

Looks like that should do it .. exactly was I was trying to accomplish.

Thank you very much !!!

I was able to work at home this weekend and found the answer. When calling

at UDF that does not access any database table and is used more like a...

No I didn't think of that - I gave it a shot and it works like a charm. Thank

you so much for the help !!

Andrew -

I couldn't get the last sample to work but the one you last

posted works great. I'll pop that into my sproc today.

I tossed a "having count(*)...

Sergiy -

The average would be 2.6 - ( (3.2 + 2.0) / 2 ) using the

"labvalue" field.

Todd

Thanks a lot Greg,

Your code works great and I'll use it as a solution !!

Todd

Andrew -

Thanks for the suggestion but the "top" clause appears

to literally return 2 rows - not 2 rows per member.

Jeffrey -

The query should not be data dependent,...

Jetro -

Thanks for the great solution but unfortunately I am still using SQL server 2000

and have no row_numbers !!! Any other ideas ??

Thanks

Todd

Jeffrey -

Thank you for the reply. I see that your solution will work if the lab

values are there every month, but what if they skip one or two...