<div>
If all your values have the exact same length, just divide by 1000000.0?<br />

<pre><code class="code-1 nolinks" id="code-20-43317265-1"><span>select -111817259, -111817259/1000000.0;</span>
</code></pre>
<br />
Probably better to load the data into SQL Server correctly in the first place and forget about the view.
</div>


<div>
Thanks. How would this be written in a SQLQuery with the table view named dbo.Test_1 and the column named xpos? So it selects the field value of each cell and outputs the correct format (exp. -111.817259)?
</div>


<div>
Take the select I provided and use your table/columns?<br />

<pre><code class="code-1 nolinks" id="code-20-43317282-1"><span>select xpos/1000000.0 from dbo.Test_1;</span>
</code></pre>
<br />
remember, it does assume ALL column values are 9 digits.<br />
<br />
To create a view, just add the &quot;create view&quot; syntax to the select. &nbsp;I still STRONGLY encourage you to store the values correctly when you load them into SQL Server. &nbsp;It will save you headaches later.
</div>


<div>
Worked perfectly thanks! If I wanted to add another column with the same division would it be something like this?<br />
<br />
select xpos/1000000.0 and ypos/1000000.0 from dbo.Test_1;
</div>


Senior Systems Administrator

ITSysTech

<div>
One quick question. When we run the View against -11817259/1000000.0 it outputs -111.817259000 and on a calculator it outputs -111.817259 which is correct. Is there a way to remove the extra three zeros on the end in the View? Thanks
</div>


<div>
<div class="content wysiwyg-content fr-view">
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.<br>For example: from mysql exports a field value of -111817259 to mssql of -111817259 &nbsp;but needs to be &nbsp;-111.817259 for our software to use it correctly.<br>Thanks
</div>
</div>



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.
Thanks

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.