Thank you.

I was able to retreive data from the openquery statement using "SELECT *" which returns one value.

I'm having problems inserting data into my temp table because the...

Thank you very much. That's exactly what I needed!