[Solved] Cannot create the same #temp table twice in the same batch
Please see the documentation, which states: If more than one temporary table is created inside a single stored procedure or batch, they must have different names. Your code yields the following error: Msg 2714, Level 16, State 1, Line 11 There is already an object named ‘#temp’ in the database. And this is not because … Read more