Well our thoughts are if a separate table is created then we take into possibility that more potential issues for problems may arise. Therefore if we use the temp variable...

Eugene thank you.

We understand the temp table and table variable creation. Our quandary is can a temp variable be created and can that be used to pull data from?

We are...

Thanks Eugene,

We understand the temp table and table variable. What we would like is to create a temp variable from the process that we can pull from.

Is this possible?

Paul I understand this is really confusing on my first post.

What I want to do is pull and combine from two different columns in the same database to a...