<div>
cast(@pDifference as decimal(5,1))<br />
<br />
This is how I did it for anyone interested.
</div>


cast(@pDifference as decimal(5,1))

This is how I did it for anyone interested.

<div>
SELECGT ROUND(@pDifference, 1) AS RoundedValue
</div>


SELECGT ROUND(@pDifference, 1) AS RoundedValue

<div>
Good point. &nbsp;I am not sure if we want to round down yet or not... &nbsp;The example show was more for &quot;decimal places&quot; being limited to 1. I'll give you the credit for the answer though, just in case I need to use the floor function!
</div>


Good point.  I am not sure if we want to round down yet or not...  The example show was more for "decimal places" being limited to 1. I'll give you the credit for the answer though, just in case I need to use the floor function!

<div>
<div class="content wysiwyg-content">
Hello all, I have a insert statement (below) in which the @pDifference is a float. &nbsp;If the variable contains 2.7777764646 for example, I want to format so that the insert just puts 2.7 into the database. &nbsp;Please help! &nbsp;Urgent!
</div>
</div>


Hello all, I have a insert statement (below) in which the @pDifference is a float.  If the variable contains 2.7777764646 for example, I want to format so that the insert just puts 2.7 into the database.  Please help!  Urgent!

FOrmat Float

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.