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
1,4,5 a 20,11,10
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 SharmaPosted Oct 11, 2014, 2:17 AM
Munesh SharmaPosted Oct 11, 2014, 2:13 AM
Anshuman SharmaPosted Oct 11, 2014, 2:11 AM
refer this link
http://stackoverflow.com/questions/18362653/concatenate-many-rows-into-a-single-text-string-with-grouping
it will be useful for you.