Thanks Thorn ... I really appreciate your efforts . But I am not able to understand Cross Apply... Could you pls provide any useful link for it.. If you got one ?
Google, and try searching something like "T-SQL CROSS APPLY". It will give you a huge amount of information about it.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk