try this:
CAST(ROUND(attempts/total,2) as DECIMAL(12,2))
OR
attempts/CAST(total as DECIMAL(12,2))
OR
CAST(attempts AS DECIMAL(12,2))/total
Total Post:378
Points:2694CAST(ROUND(attempts/total,2) as DECIMAL(12,2))
OR
attempts/CAST(total as DECIMAL(12,2))
OR
CAST(attempts AS DECIMAL(12,2))/total
Total Post:110
Points:776ASP.Net ASP.Net Gridview
Ratings:
941 View(s)
Rate this:
I am trying to round the result of my code to 2 decimal places, but ROUND isn't working. Any help? Thanks!
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [Id], [attempts], [total], (round(attempts / total,(2))) AS [Percentage] FROM [Game]">
</asp:SqlDataSource>