I do use temp filenames in some of my procedures. You're saying that if I create a table with #filename in my main SP, the SP's I call from my main SP can call that filename? However the SP I call would have to know the #filename is, or would I pass the #filename as a parameter?