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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-11 : 09:23:04
|
| Gopinath writes "Let us consider we have the following data in a table,Column1 Column2John orangeJohn appleJohn GrapeSteve orangeSteve watermelonSteve pineapplein the above table, i want to query and get output in the below formatColumn1 Column2John orange apple GrapeSteve orange watermelon pineappleis it possible? if yes, kindly let me know the query.Thanks in advance.Regards,Gopi." |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-11 : 09:31:12
|
| Can't u do ur formatting in the Front End ?Srinika |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-11 : 11:42:36
|
| Where do you want to show the data?If you use reports, make use of Suppress if duplicated featureMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Query Output in a desired way