Solutions to common T-SQL problems

Some of the moderators over at the MSDN SQL Server Forums have got together and collated a reference of solutions to common T-SQL problems.

As always, all quality resources get added to the SQL Server Resrouces area of this site.