Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
emceemic
Starting Member
1 Post |
 Posted - 2010-05-06 : 10:44:33
|
| Hello guys,Question about sql select... Is there a way to show multiple rows per row if required??For example, say the table I currently have show the following data:Impact to Business, Business Owner Name, Breakdown1)Application, John Doe, Application2)Hardware, Joe Smith , Hardware3)Multiple , John Doe , 1:Hardware 2: ApplicationThis is how the data is stored in the datatable itself.Is there a way I can separate the 'Multiple' one to show individual info in different rows? ideally, the table I need is:Impact to Business , Business Owner Name , Breakdown1)Application , John Doe , Application2)Hardware , Joe Smith , Hardware3)Multiple , John Doe , 1:Hardware, 2: Application4)Hardware , John Doe , Hardware5)Application , John Doe , ApplicationI am using Crystal Reports to fetch data from database, so I cannot create a dummy table that would do the job.. is there a way of doing this using SELECTs???Thanks!Michael Process Analystprogrammer |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
show multiple rows per row as required