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 |
|
Ali Chadorbaf
Starting Member
44 Posts |
 Posted - 2008-01-02 : 16:49:26
|
| HiI am looking for a function or so to format a number to two digits plus one decimal point. Some examples:- if input=4 then output= 04.0- if input=40 then output= 40.0- if input=4.1 then output= 04.1- if input=4.32 then output= 04.3Any idea? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-08 : 08:50:00
|
| You can make use od Derived column task for this. |
 |
|
|
|
|
|
SSIS - Script components