mdaniel:

When I run your query in Query Analyzer against a MS SQL Server 2000 database, the results show a bunch of empty rows that display the table_catalog, table_schema, table_name, column_name,...

Ninja,

Interesting, but not the one I'm looking for. Maybe someone here has seen the one I'm seeking in another forum?

Ninja: Could be. Please send link and I will let you know if that's it.

We are fans of DB Documentor, which produces a nice compiled Help file (.chm) that opens on any Windows box, or an HTML output file viewable in a browser. $199.

...

James,

Yes, you captured the essence. (I understand that UPSERT might be available in SQL Server 2005?)

I was able to do what I want, slightly enhanced, in SQL Server 2000 with...

With a slight change:

SELECT DISTINCT t1.OrgID

That is IT!!!!!!!

Thanks, PW

Thank you Auntie! I will look into your tips.