Remove decimal places without rounding

There was a script here not too long ago which showed how to 'truncate' a number to two decimal places without rounding. This used a lot of casts to varchars and back.The solution worked, but I knew there had to be a way of doing exactly this without having to go back and forth between […]

2005-08-08 (first published: )

534 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

What is spinlock ALLOC_CACHES_HASH?

By My_Sky

Hi, Queries are slow, cpu usage at 80%. ALLOC_CACHES_HASH backoffs start at same time...

BULK insert several thousand files

By MVDBA (Mike Vessey)

I have a bunch of logging data that my sysadmin has downloaded from our...

SSRS 2016 install on FCI with AAAG.

By snomadj

Appreciate advice here as I am slightly confused. I need to install SSRS 2016...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers