title: What would be a better approach a temp table or ordinary table?
body: <p>I have a stored procedure where I need to hold some data and process it.I am using a temp table (#temp) for this purpose. Now as temp table is stored in tempDb and this will cause an inter database communication so would it be better to create a normal table? Is there any other benefits of #temp table? </p>