User Defined Function in sql server.

Question

Hai Friends I am having a table as follows: ID Row1 Row2 1 a 20 2 b 12 3 c 16 4 a 11 5 a 10 6 c 18 7 b 15 When we pass a from Row1 in a query we should get the output as follows: ID Row1 Row2 145 a 201110 I should get it by using functions(UDF's). I have tried a lot friends but unable to get the solution. Please any one provide me solution for this. Thank you.

Munesh Sharma · Answer

take this query for your desire o/p SELECT row1 ID= STUFF((SELECT ' ' +ID FROM temp t WHERE a.row1=t.row1 FOR XML PATH(''))12'')row2= STUFF((SELECT ' ' +row2 FROM temp t WHERE a.row1=t.row1 FOR XML PATH(''))12'') FROM temp a GROUP BY a.row1

Munesh Sharma · Answer

SELECT row1 ID= STUFF((SELECT ' ' +ID FROM temp t WHERE a.row1=t.row1 FOR XML PATH(''))12'') FROM temp a GROUP BY a.row1

Anshuman Sharma · Answer

Hi. refer this link http://stackoverflow.com/questions/18362653/concatenate-many-rows-into-a-single-text-string-with-grouping it will be useful for you.