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 |
|
Rudys
Starting Member
8 Posts |
 Posted - 2008-02-17 : 11:28:46
|
Hi All.I'm new in SQL i have a problem when export mytable to text file.below is my result export my table use a bcp:0714142020 KURNIA 63360 86 0614142469 HATA 6666444 36J my problem is how to make a third column to right alingment like below.0714142020 KURNIA 63360 86 0614142469 HATA 6666444 36JThanx |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-02-17 : 16:06:47
|
Why on earth do you want to do that?!
George<3Engaged! |
 |
|
|
Rudys
Starting Member
8 Posts |
Posted - 2008-02-17 : 22:43:52
|
quote:
Originally posted by Rudys
Hi All.I'm new in SQL i have a problem when export mytable to text file.below is my result export my table use a bcp:0714142020_____KURNIA_____________63360.00____________86 0614142469_____HATA_______________6666444.00__________36J my problem is how to make a third column to right alingment like below.0714142020_____KURNIA_______________63360.00__________86 0614142469_____HATA_______________6666444.00__________36JThanxSorry the 1st post i think the data is maze couse the position of the data is no corret, n the underscore mean the space. I wanna do that couse my other application read the third column as numeric and that is the spec should i follow, and i had change my third column to numeric n when i export it to text files it still left alingmnetTQ
[size=4] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-18 : 03:40:42
|
| Dont you think you should do this in Reports?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
alingment problem when export data to text file