>Although I don't understand how to do item 4) in your list. How do you create a temp table in SQL Server without a stored procedure?

The same way you would create it in the stored procedure, with SELECT INTO or CREATE TABLE but sending them from frontend.