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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-11-30 : 03:04:30
|
| I have table date like this///COL1 COL2 COL3==========================================A HI HOW R U YES ARE YOU FINE HELP ME PLEASEB YES GIVE YES ME THE QUERY WE CAN HELP IT OUT==========================================out put shud be COL1 COL2 COL3==================================================================A HI HOW R U ARE YOU FINE HELP ME PLEASE YES B YES GIVE ME THE QUERY WE CAN HELP IT OUT YES================================================================== |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-30 : 03:25:31
|
| not very clear from your layout above but i think you just mean...select COL1 + ' ' + COL2 + ' ' + COL3from urTableEm |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-11-30 : 03:58:18
|
| COL1 COL2 COL3==========================================A HI HOW R U YESA ARE YOU FINEA HELP MEA PLEASEB YES GIVE YESB ME THE B QUERYB WE CAN HELPB IT OUT==========================================OUTPUT SHUD BE =========================COL1 COL2 COL3A HI HOW R U ARE YOU FINE HELP ME PLEASE YESCOL1( A ) has 4 lines( ROWS ) in col2,so 4 line(ROW) shud be in single line(ROW). |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
NEED QUERY