How to do partitioning on a ID columns

Database
Enthusiast

How to do partitioning on a ID columns

We have a decimal value column, can anyone please advice how to do partitioning using that column.

Thanks in advance. 

Tags (1)
2 REPLIES
Junior Contributor

Re: How to do partitioning on a ID columns

Try CAST(decimal_col AS INT)

Enthusiast

Re: How to do partitioning on a ID columns

Thankyou Dieter.

That worked.