Best Practice

Technical Article

RE: formating the number

  • Reply

Why mess around with rounding when rounding is to be avoided? Just cast the decimal to a string and chop it from left side to 2nd position after the decimal point(assuming all cases are like the example)declare @d decimal(6,4) set @d = 34.2399 select @d select substring(cast(@d as varchar(11)), 1, charindex('.', cast(@d as varchar(11))) + […]

2004-08-25

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers