Create a function from a Procedure

[joelias]

Hi, I have a proc and it creates a temp table with business rules. There is a second select within the proc that uses some columns from this temporary table and then updates the temporary table and then updates the fixed table. I want to put these selecs inside a function without changing anything in the rule. How can I do this without having to create the temp table?

[#2]

Since my ability (probably other people here too) is very poor at reading minds and I can't test your server, please provide less vague stories (description of SP) and more details like the code of the SP and all relevant. In addition please try to present the expected result you want to get. Thanks