Losing Decimal precision in open query+sql server

Copper Contributor

Hi Team,

Querying data from Open Query. One column with Decimal datatype losing its precision. In source column value 123.234 

SELECT * FROM OPENQUERY (XXXX, 'select Cloumn from XXXX where columnname=''1234''')

 

After selection from open query result its displaying in sql server as 123.000 

1 Reply
To less on informations.
What the type of data source (RDBMS) and what's the source column data type?