Get concatenated value for a column without cursor

This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.