yes, I figured that when I omited the end as diag_1 from the end and still got the column of data.....where am I getting that last column from in the...

thx

What is OP? Be kind guys

Doesn't that give you the age as of the day it is run?

All hail the SS Carpal Tunnel....she works she works!!!

Where should datediff go?

Thanks...but I keep getting the errors:

Msg 207, Level 16, State 1, Line 22

Invalid column name 'aid'.

Msg 207, Level 16, State 1, Line 22

Invalid column name 'aid'.

Msg 207, Level 16, State...