Display Number as below style in sql server

Question

In Sql server:

If i give one value as 1500

Then number should be display as 2 different options like:

1-1000
1001-1500

That Means Here i am splitting 2nd option after 1000,so finally i need dynamically if  i give any value.

For Example:
value=3699

Then
1-1000
1001-2000
2001-3000
3001-3699

Answer 1

All SQL Server related forum moved to Question & Answer at https://docs.microsoft.com/en-us/answers/products/sql-server ; better ask there.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]