SQL Server Performance Forum – Threads Archive
decimal value
HiWhen I query out iam getting the result as 23.0,34.0,45.0 etc… but I dopnt want to represent in this way in my reports, i just need 23,34,45….. how can i do this from sql.
any help. Thanks!
"He laughs best who laughs last"
Where are you showing this report? Can’t you do the formatting there?
If it needs to be in T-SQL I would CAST(… AS INT) (ignoring rounding issues here). —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
yeah i cud do this in sql but i am not getting in my reports.
anyways thanks frank. Thanks!
"He laughs best who laughs last"
In your report cant you use Truncate, ceiling or Floor functions? Madhivanan Failing to plan is Planning to fail
]]>