I am all in favor of fair trade and global competition, but you that doesn't mean you have to say, "It's Darwinism, nothing to be done."

Perhaps tariffs and their ilk...

Another option is to use a table variable, populate it with data, then you can reference it multiple times.  Perhaps not as fast as a CTE (I don't have SS 2005...

srqanqu,

I just did what you want.  You don't need to do anything special to have a temp table visible in a called SP.

EXAMPLE:

------------------------------------------------

SP-1: 

Creates temp table #MyTemp

Calls SP-2

------------------------------------------------

SP-2:

Get data from...