Sean thanks so much for your help. Based on your previous response I was able to figure out what I needed to do. I just needed to add...

Yes, I am placing it into a table variable for use later in my larger stored procedure.

The table you are seeing is what was inserted into @customer_applications_products from the select...

In this particular instance there won't be different site id's because the data that will be inserted into the temp table will only be for one site.

Thanks!!! That works great!

The number of columns returning are dynamic. I will be selecting a range and will need them returned as one row.

Sorry I accidentaly posted before I was finished writing.

If I understand what you are trying to return (which is only those rows with h.source_channel = '3') then you need to add a where clause as shown below and...

I'm not sure how you have things configured, but on my server I have to leave Outlook open because I have a interval of 5 minutes on my send/receive and...

I also get this message when trying to connect to my server via Query Analyzer.  I drop about every 5 minutes.  When you stated 'try to ping the dbserver f.ex.',...

I got it.  Thanks for the help.