Forum Discussion

durga1420's avatar
durga1420
Copper Contributor
Sep 27, 2023

Losing Decimal precision in open query+sql server

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 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Sep 28, 2023
    To less on informations.
    What the type of data source (RDBMS) and what's the source column data type?

Resources