Column Pivot using COALESCE command:
I read this in an article today and thought worth sharing with you.
DECLARE @val VARCHAR(1000)
SELECT @val = COALESCE(@val,'') + col1 + ';'
FROM table1
SELECT @val
The above command would concatinate the output of the column col1 in table1(say 100 rows) into a single column value. We can avoid using cursors.