>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 ?
>

Hi Stephen,

If you considered and ruled out set oriented solutions, than you have two choises: temporary table or table variables. See INF: Frequently Asked Questions - SQL Server 2000 - Table Variables mskb #305977 for some pointers.