November 29, 2006 at 10:30 pm
I am extracting data into text file using dts. Column format in decimal(14,2). All "0.00" values are extracted as ".00"
In Query Analyser results also shown as ".00"
Is there any way to keep 0 before decimal point in output? Configuration settings?
November 30, 2006 at 9:17 am
Have a look at this discussion thread and examples: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=10482
Francis
November 30, 2006 at 11:20 am
I know I can covert it to string and do any formatting I want, but since all I want is to extract number that are less then 1.0 as "0.75", not as ".75". SQL shows float numbers this way, but not numeric or decimal..
I thought it could be some server settings that allow to do it.
Accepted answer:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=326613
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply