HI Guys,
I'm trying to take a ms sql server 2008 column and merge it into a nvarchar. So instead of being a column it will be come a file. Does anyone know how to do that in a stored procedure?

Say you have a table with a column "Names"
john
mary
jack
joe

How do you merge all these cells into a single string so now it would be:
"john mary jack joe"

thanks.