>Yes Sergey I did,
>
>Your recommendation to make a Variable instead of a temp Table. That sound great, but how SQL return that set of Variables as a table back to the front end. Sorry for that question but I am not a SQL Guru.

Apparently you didn't. I recommended to use 'a table variable' not variables. A table variable is a special kind of 'in memory' table and in many cases can replace a temp table.

Also, you never explained why can't you use the same stored procedure in multiple places.