This article does an excellent job of explaining string concatenation in SQL, particularly the use of STUFF to remove unwanted delimiters like leading commas or semicolons. While there are many...