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 |
|
DURGESH
Posting Yak Master
105 Posts |
 Posted - 2008-12-01 : 04:35:34
|
| hi all,i have prepared a table using xml document.In that table there is a problem that, it is display a single tag contents into two rows. But I want all tags should be in a single row.can any body help me to solve this issueThanks in Advance RegardsDurgesh J |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-01 : 04:46:05
|
| are tag conetents single field value? if yes, it might be because of presence of linefeed characters.then try like belowselect replace(tagfield,char(13)+char(10),'') from yourtable |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-01 : 04:50:07
|
| Post the code you usedMadhivananFailing to plan is Planning to fail |
|
|
|
DURGESH
Posting Yak Master
105 Posts |
Posted - 2008-12-02 : 02:05:14
|
| hi visakh,i am reading xml file using XP_CMDSHELL |
|
|
|
karthickbabu
Posting Yak Master
151 Posts |
|
|
|
|
|
how to linefeed characters from xml