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 |
|
sparrow
Starting Member
20 Posts |
 Posted - 2008-02-27 : 15:38:10
|
| I am adding a new column with the derrived column data flow Transformation and am having a problem with it coming through as a deciaml format.The destination column is set as "numeric(18, 9)" but no matter what i change the data type to in the transfomation editor it will only bring through the calculation as a whole number (IE it rounds the number up) The destination table shows the zero's after the "." What do i need to do to get this coming through as a number with decimalsHeres the expression i am using (PROG_CREDITS / (PROG_DURATION / 12)) / 120Cheers |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-02-27 : 16:08:07
|
| (PROG_CREDITS / (PROG_DURATION / 12.0)) / 120.0"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
sparrow
Starting Member
20 Posts |
Posted - 2008-02-27 : 17:14:00
|
| Thats the one Cheers |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-28 : 01:23:11
|
PROG_CREDITS / PROG_DURATION / 1440.0
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Data problems with Derived Column