This looks good but what if you have more than 1, then how would I make the program dynamic to pull 1, 2,3 4, elements...

Hi there

When will your next series come up? I think you mentioned that you will cover on transforming XML file into a table.

When you do this, can you make...

Lets assume same table A is in 2 different instances. Both instances being 2008 SQL Server.

select a.col from table_name a

except

select * from openquery(servername,'select col from table_name')

if you have...

ha ha..Well, they can have one cruise around all corners then. (similar to sql saturdays)

Turn over will be huge though.

If they host it around New England region it would be great...