<div>
Assuming that sidstrNBR_MO_ACT_FED_SVC is NOT [tiny][small][big]int...<br />
<br />
Select Cast(sidstrNBR_MO_ACT_FED_<wbr />SVC /12 as numeric(10, 2)) from tblsidpers<br />
<br />
If it is [tiny][small][big]int...<br />
<br />
Select Cast(sidstrNBR_MO_ACT_FED_<wbr />SVC /12.0 as numeric(10, 2)) from tblsidpers
</div>


Assuming that sidstrNBR_MO_ACT_FED_SVC is NOT [tiny][small][big]int...

Select Cast(sidstrNBR_MO_ACT_FED_SVC /12 as numeric(10, 2)) from tblsidpers

If it is [tiny][small][big]int...

Select Cast(sidstrNBR_MO_ACT_FED_SVC /12.0 as numeric(10, 2)) from tblsidpers

<div>
Wow answers a minute apart. &nbsp;Thanks for the quick help.
</div>


Wow answers a minute apart.  Thanks for the quick help.

<div>
<div class="content wysiwyg-content">
I am selcting a field that shows the number of months. &nbsp;So I am dividing by 12 to get the years, but I get a decimal string that I want to consolidate. &nbsp;So i tried CAST and Round but got whole numbers. &nbsp;Then I also have problem of dividing by zero. &nbsp;So how can i check for zero and show only like example below.<br />
<br />
For example If Ithe field has 91 months it comes out as <br />
7.583333333333<br />
I would like it to be 7.58<br />
<br />
Select Cast(sidstrNBR_MO_ACT_FED_<wbr />SVC /12 as float) from tblsidpers
</div>
</div>


I am selcting a field that shows the number of months.  So I am dividing by 12 to get the years, but I get a decimal string that I want to consolidate.  So i tried CAST and Round but got whole numbers.  Then I also have problem of dividing by zero.  So how can i check for zero and show only like example below.

For example If Ithe field has 91 months it comes out as 
7.583333333333
I would like it to be 7.58

Select Cast(sidstrNBR_MO_ACT_FED_SVC /12 as float) from tblsidpers

Check for zero and show 2 deciamls in t-sql

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.