Query Help!!!

[happyIndian100]

I have a TableA with the following data:
------------
Col1 Col2
-----------
A A1
A A1
A A1
B B1
B B2
C C1
C C2
C C3
D D1

i need to get this Query Result:

A A1,A1,A1
B B1,B2
C C1,C2,C3
D D1

Thanks in Advance

 

[MikeBronner]

I had a similar problem. Here's what you need to do:

CREATE FUNCTION concat_values
(
	@column_1 VARCHAR(255)
)
RETURNS VARCHAR(8000)
AS
BEGIN
	DECLARE @result VARCHAR(8000)

	SET @result = ''
	SELECT @result = @result + col_2 + ','
	FROM table_a
	WHERE col_1 = @column_1
	ORDER BY col_2
	
	IF RIGHT(@result, 2) = ','
		SELECT @result = LEFT(@result, LEN(@result) - 2)

	Return @result
END

Then run the following query:

SELECT col_1
	,concat_values(col_1)
FROM table_a
ORDER BY col_1

I haven't tested this code, but it should get you in the right direction.

Take Care,
Mike

 

[happyIndian100]

Thank You Mike it helped me a lot.