You Rock!

The first version of that worked as easy as can be! I was able to join that to the other tables and had my output in 2 minutes...

Thanks for the advice, never knew about the connector.  And the linked server idea sounds pretty promising.  If I have to switch back this sounds like the way to go.

Bob

Thanks all for the replies, I'm still reading though a few of them.

Ray - I wish this were homework, at least then I could ask a prof a question

Thanks Aaron, i think it should be working now. 

I was playing with the exist clause because I saw an example in a stored procedure, but I guess it was ment...

Ah, thanks for clearing that up (and it worked perfectly BTW)!

Thanks for trying to get a response.

a few weeks ago we ended up with a solution to this problem. The report author was able to create some XML files...