I am trying to query from a temp table and i keep getting this message: 1 as 1 12 as 12 but 1.23456789 as 1.23 the number. As well as the suggestions given already, there is one other possiblity i can infer from your question:
Using custom number formatting #,##0.00 and #.##0,00 in vba produces unwanted results asked 2 years, 11 months ago modified 3 months ago viewed 11k times Can somebody tell me what the problem is? The 00 specifier causes the value to be rounded to the nearest digit preceding the decimal, where rounding away from zero is always used.
How can i, without using formulas, show integers as integers, but decimals limited to a specific number of decimal places? 54.9 as 54.90 regardless of the length of the decimal or whether there are are any decimal places, i would like to display a decimal with 2 decimal. The default value for int is 0 , for string is and for boolean it is false. For the analogous issue with the standard library decimal class, see how can i format a decimal to always show 2 decimal places?.
Could someone please clarify what the default value for guid is? If i got your question right you need the output in the mentioned format. For example, formatting 34.5 with. Msg 102, level 15, state 1, line 1 incorrect syntax near ' '.