I am designing a report in a SQL Server stored procedure that is going to take more work to create than a simple select statement. I will have to add
and delete record from the result set after the initial select statement, and the report needs the ability to be run by more that 1 user at a time. I started looking into SQL Server temporary tables as a solution. Does anyone
know if this is the right way to go or is there a better way of performing this task ?

Thanks For Your Help !
Stephen J. Hunt