var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Import table - sign problem
I have imported a table from Oracle to SQL server using the tool in enterprise manager.
Some of the columns were numeric and had negative values.
In Query analyzer these numbers show up as positive. But when i add a where clause and only ask for the values < 0 the same numbers show up bit still without a negative sign.
Does anyone have an explanation for this?
(could have found some help if the search function was working....)
Bizarre...Is it a setting?
EDIT: what did the Column datatype transform as?
CREATE TABLE myTable99(Col1 decimal(15,4))
INSERT INTO myTable99(Col1) SELECT -123.4567
SELECT * FROM myTable99
DROP TABLE myTable99
I assume you used DTS....
Why not use PL/SQL to export the data then bcp the data in?
Also what version of Oracle?
Did the EVER come up with an unload utility?
Last edited by Brett Kaiser; 05-24-04 at 10:24.
Found a working solution.
I was using the ODBC connection to get the data via DTS Import.
When testing with datasource = Oracle Provider for OLE DB the numbers was correct!