<div>
SELECT CAST(totalamt AS DECIMAL(9,2)) AS TotalAmount<br />
FROM table1<br />
<br />
OR<br />
<br />
SELECT ROUND(totalamt, 2) AS TotalAmount<br />
FROM table1
</div>


SELECT CAST(totalamt AS DECIMAL(9,2)) AS TotalAmount
FROM table1

OR

SELECT ROUND(totalamt, 2) AS TotalAmount
FROM table1

<div>
Brain,<br />
I need the output in varchar
</div>


<div>
I first question is &quot;Why?&quot; since this should be handled at the presentation layer but just wrap it in a CONVERT/CAST to varchar.<br />
<br />
SELECT CAST(ROUND(totalamt, 2) AS VARCHAR) AS TotalAmount<br />
FROM table1
</div>


I first question is "Why?" since this should be handled at the presentation layer but just wrap it in a CONVERT/CAST to varchar.

SELECT CAST(ROUND(totalamt, 2) AS VARCHAR) AS TotalAmount
FROM table1

<div>
I am exporting the output to CSV. &nbsp;So the column should be string.
</div>


I am exporting the output to CSV.  So the column should be string.

<div>
I have used the below script. But the output still showing the third decimal 0 <br />
<br />
SELECT &nbsp;CAST(ROUND(totalamt, 2) AS VARCHAR) &nbsp; AS &nbsp; TotalAmount<br />
FROM table1<br />
<br />
<br />
Output:<br />
834.200<br />
3015.380
</div>


I have used the below script. But the output still showing the third decimal 0

SELECT  CAST(ROUND(totalamt, 2) AS VARCHAR)   AS   TotalAmount
FROM table1


Output:
834.200
3015.380

<div>
if it is available to you (version SQL 2012 onward) try <a href="https://msdn.microsoft.com/en-AU/library/hh213505(v=sql.110).aspx" rel="ugc">FORMAT()</a><br />
<br />
e.g.<br />
<br />
FORMAT(totalamt,'0.00')
</div>


if it is available to you (version SQL 2012 onward) try FORMAT() [https://msdn.microsoft.com/en-AU/library/hh213505(v=sql.110).aspx]

e.g.

FORMAT(totalamt,'0.00')

<div>
<div class="content wysiwyg-content">
select &nbsp;convert(varchar,totalamt ) as TotalAmount &nbsp; from table1<br />
<br />
Output: &nbsp;18882.019<br />
<br />
15882.050<br />
8078.816<br />
<br />
I need the output in the following format &nbsp;(need only two decimal places). How do i achieve this ?<br />
18882.01<br />
15882.05<br />
8078.81
</div>
</div>


select  convert(varchar,totalamt ) as TotalAmount   from table1

Output:  18882.019

15882.050
8078.816

I need the output in the following format  (need only two decimal places). How do i achieve this ?
18882.01
15882.05
8078.81

SQL query output only need  two decimal places

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.