convert Float

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  June 8, 2009 at 12:24 pm

  #134844

  I am exporting float field as 0.006 to the flat file and when I open file the data looks different,what should I do?

• J-F Bergeron

  SSCrazy Eights

  Points: 8593

  More actions

  June 8, 2009 at 12:53 pm

  #1006267

  What does it look like once you export it, and how do you export it, can you show us the query you ran?

  Thanks

  Cheers,

  J-F

• WayneS

  SSC Guru

  Points: 95460

  More actions

  June 8, 2009 at 9:01 pm

  #1006395

  Krasavita (6/8/2009)

  ---

  I am exporting float field as 0.006 to the flat file and when I open file the data looks different,what should I do?

  Use the STR function with the proper parameters to control it's size and # of decimals.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2