<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
Can someone please help me with this basic question. I need to get 2 digits after decimal point in sql server. Doing the following in sql query analyzer;<br />
select 10/3 gives me 3. &nbsp;I need to get 3.33<br />
If I do the calculations inside the stored procedure, same thing happens and I do not get digits after decimal. Thanks
</div>
</div>


Hi Experts,
Can someone please help me with this basic question. I need to get 2 digits after decimal point in sql server. Doing the following in sql query analyzer;
select 10/3 gives me 3.  I need to get 3.33
If I do the calculations inside the stored procedure, same thing happens and I do not get digits after decimal. Thanks

sql server 8.0 - Function and format to get 2 digits after decimal points

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.