I have got a SQL Server with a linked server to a MySQL DB. I'm using an openquery to insert into the MySQL DB everything works fine except that any MySQL Decimal(19,4) that is getting data from SQL Server end up being 10,000 times bigger ex. SQL 123.45 > MySQL 1234500.0000 INSERT INTO OPENQUERY (MYSQL, 'SELECT * FROM MySQL_Table') SELECT * FROM dbo.SQL_Table GO has any one had this problem? and if so what did they do?
Rather than using **select \***, try to spell out the column names of the **dbo.SQL\_Table** and cast the problematic column as decimal(19, 4), i.e: INSERT INTO OPENQUERY (MYSQL, 'SELECT * FROM MySQL_Table') SELECT col1, col2, -- etc cast(trouble_column as decimal(19, 4)) as trouble_column, -- other columns FROM dbo.SQL_Table; GO Oleg