Below is a list of all the SQL Articles I've regularly used in questions. If you are particularly proud of an article, please post it here.
Beware of Between - PortletPaul
In case it helps, SQL expert PortletPaul
addresses this in his article Beware of Between
. An excellent read, and if it helped you click on the green 'Was this article helped you?' button at the end.
Table Joins Explained - chapmandew
For more reading on JOINs check out Tim Chapman's article SQL Server: Table Joins Explained!
Also to get your head wrapped around the different JOINS I recommend going to images.google.com and search for 'SQL TABLE JOINS', and check out all the pretty cartoons on joins.
Comma-separate list as a parameter - angelIII
Here's an article called Delimited list as parameter: what are the options?
that shows how to deal with comma-separated multiple values passed in a variable.