You can have multiple values of a column in single row with the help of following query in sql :

DECLARE @Result varchar(MAX)SELECT @Result=COALESCE(@Result+',','')+ fieldname from fielddefsselect @result