How to display multiple row value in one column | 23 Feb 2010 01:02:51 |
| | Hi Experts,
One of users need display multiple rows value in one column in SQL Select statement.
Sample Table
ID Name Email Phone
1 John John@codegain.com 12345656
2 Peter Peter@codegain.com 23423424
3 Test Test@codegain.com 43233234232
4 dummy dummy@codegain.com 4234234
Expect Output
all are in one row .
Thank you | |
| | | |
| Re:How to display multiple row value in one column | 23 Feb 2010 01:02:51 |
| | You can write a stored procedure which will select the required records, form a comma separated string.
That is the only option as far as i know. | |
| | | |
| Re:How to display multiple row value in one column | 23 Feb 2010 01:02:51 |
| | | | |
| Re:How to display multiple row value in one column | 23 Feb 2010 01:02:51 |
| | Hi
Is any sample to this work around?
thank you | |
| | | |
| Re:How to display multiple row value in one column | 23 Feb 2010 01:02:51 |
| | Hey,
Try to get here,
[url]http://vinothnat.blogspot.com/2009/06/multiple-rows-in-single-rows-with.html[/url] | |
| | | |
| Re:How to display multiple row value in one column | 23 Feb 2010 01:02:51 |
| | | | |
|