General information
Forum:
Microsoft SQL Server
Title:
Currency Field in DTS
Hello All,
I was wondering if anyone has run across this... We have been
pulling our hair out for some time with this...
When converting a money field from Sybase 11.0.3.3 SWR 7930 Rollup
to SQL 7.0 using a standard DTS transformation, if the value of the field ends with "0.00", the zero(s) to the left of the decimal get truncated ...
Examples ...
Sybase SQL 7.0
1234.00 1234.00
1230.00 123.00
1200.00 12.00
Anyone else seen or experienced this??
Thanx!
Bob
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only