I'm importing data from an XML file into SQL Express using SQLXML 4.0 through a vb.net app. The numbers in the xml's are whole numbers, meaning no decimal places or points exist.
However, the numbers do represent a number with 2 decimal places.
So 59455 is actually 594.55
15500 is 155.00
I've tried data type decimal(10,2) but all this does is treat 59455 like 59455.00 which is incorrect
If I use data type decimal(10,0), then 59455 is imported as 59455 which isn't entirely correct either.
Of course decimal(10,-2) doesn't work.
Is my only recourse to create a function and convert these number values with a precision and scale of 10,2 manually?
Or is there a data type that'll force the placement of the decimal wherever desired?
However, the numbers do represent a number with 2 decimal places.
So 59455 is actually 594.55
15500 is 155.00
I've tried data type decimal(10,2) but all this does is treat 59455 like 59455.00 which is incorrect
If I use data type decimal(10,0), then 59455 is imported as 59455 which isn't entirely correct either.
Of course decimal(10,-2) doesn't work.
Is my only recourse to create a function and convert these number values with a precision and scale of 10,2 manually?
Or is there a data type that'll force the placement of the decimal wherever desired?