Hi All,
I need to BCP a file out and maintain it's format so it can be loaded into a system other than SQL Server. I have currently having a problem with the float data type.
Please see this example:
create table bcptest2
(FlatRate float)
insert into bcptest2
select 0.003
exec xp_cmdshell 'bcp YourDBName.dbo.bcptest2 out C:\\bcptest2.dat -c -C RAW -t"|" -T'
Instead of outputting 0.003 I get 3.0000000000000001E-3.
I need to use bcp to do this and have had a look on the MSDN website at the different format switches. Am I missing anything obvious?
The system accepting the output is expecting a decimal value and therefore throws errors when it comes across this value.