I was hoping I wouldnt have to do that, does MS have any best practices for where the binaries and dll files should be installed?

well I don't have CLR and would prefer to not do anything with cursors, so what I will do is load a history table with all data prior to...

thanks for pointing me in the right direction!

essentially yes I am trying to run totals, and I only want to display unique data based on that select distinct join.

Wildcat (3/21/2012)

---

Try this:

SELECTLAST_NAME,

FIRST_NAME,

[ADDRESS] = (SELECT STUFF((SELECT ' ' + ADDRESS_LINES

FROM yourTable

WHERE ID = a.ID

ORDER BY POS

FOR XML...