Thank you all for responding.

Yes, DCPeterson, creating that many temp tables is what I was afraid of.

I will look into Matt's suggestion, but I'm not sure it would be any easier.

And Quickly Confused is right, there is no auto way to do this

since none of the stored procedure output have the common columns.

This is what I needed to hear before I proceed.

thanks a bunch.