   [web] (SQL Server) How to concatenate the select results into one cell?
  Hi, I'm using sql server and I want to concatenate the results of a select into one cell.eg If I:select * from SomeTable;and the results returned like so:0 aa1 bb2 cc3 ddI want to concatenate all the results so they return as one line:0 aa 1 bb 2 cc 3 ddis this possible, and how would I go about it?Thanks   
  You'd have to make a stored procedure.   ;  I know a bit about stored procedures, eg how to use them with basic sql scripts, but how would I manipulate the results to be concatenated? ..like how would I loop through the columns and rows?;  There is GROUP_CONCAT funtion in MySQL. You can use statement like this:SELECT   GROUP_CONCAT(CONCAT( `name` , ' ', `value` )SEPARATOR ' '   )FROM `table`