-
as seen on Stack Overflow
- Search for 'Stack Overflow'
i have value stored in string format & i want to convert into decimal.
ex:
i have 11.10 stored in string format when i try to convert into decimal it give me 11.1 instead of 11.10 .
I tried it by following way
string getnumber="11.10";
decimal decinum=Convert.ToDecimal(getnumber);
i tried…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi there,
I'm having trouble with a query in SQL Server 2008 on some forex trading data. I have a trades table and an orders table. A trade needs to comprise of 2 or more orders. DDL schema and sample data below.
What I want to do is write a query that shows the profit/loss in pips for each trade…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have to round down all incoming data with type DECIMAL(14,3) which has 3 decimal digit to the last one. I.e.:
100; 100.0; 100.00; 100.000 -> 100
100.2; 100.02; 100.20; 100.22 -> 100.xx
but
100.221 -> 100.22
100.229 -> 100.22
Using which SQL operator can I check that residue of…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a source XML that uses a dot (".") as a decimal separator and I am parsing this on a system that uses a comma (",") as a decimal separator.
As a result, value of 0.7 gets parsed with Double.TryParse or Double.Parse as 7000000.
What are my options to parse correctly? One of them is to replace…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have to round down all incoming data with type DECIMAL(14,3) which has 3 decimal digit to the last one. I.e.:
100; 100.0; 100.00; 100.000 -> 100
100.2; 100.02; 100.20; 100.22 -> 100.xx
but
100.221 -> 100.22
100.229 -> 100.22
Using which SQL operator can I check that residue of…
>>> More
