decimal value | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

decimal value

When 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
Heute schon gebloggt?

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