SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...

Both examples are relevant to both DBs. The first example is what I'm trying to do: combine the contents of two tables using a subquery. This works fine in SQL Server but not in MySQL.