Avatar of ITSysTech

asked on 

MSSQL 2019 create a table view that adds a decimal place to each column fields

We have a database that is pulled from a mysql database and replicated into a MSSQL database however, the fields in the column need an decimal added.
For example: from mysql exports a field value of -111817259 to mssql of -111817259  but needs to be  -111.817259 for our software to use it correctly.
MySQL Server

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon