Be great if the author could publish a part 3 to this series of articles. a lot can happen in 2yrs in this big data world. especially with...

Thanks Charles. Now I understand.

Does anybody have any advice on the "best" way to install the dlls that support CLR based stored procs and UDF's? What i mean is where should these .dll...

:blush: No. only if i ditch that idea and left join against it from a table that has that record..

eg

select a.id, isnull(b.fName, 'N/A') fName

from (select '1234 ' id,...

What about...

SELECT isNull((SELECT MIN(CASE WHEN fName IS NOT NULL THEN fName ELSE 'N/A' END) FROM t_Names WHERE id = 1234),'N/A')

regards

JA