thomasrushton

SQL Server DBA - part-time since 1995, full-time since 2010.

Function to express numeric value in words

There is a requirement here to take a number (such as 124995) and express it in words.  We needed a function to do this, as it would be used in an existing document generation system.I have developed the enclosed two functions to do this.  Note that the function does not, currently, cater for negative numbers, […]

2002-12-06

98 reads

Blogs

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Error creating Azure SQL Database

By

A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What...

Read the latest Blogs

Forums

Splitting a group up into multiple groups using a score....

By Rob Reid-246754

Splitting a group up into multiple groups using a score for how many times...

Whether to leave a clustered index on a staging table

By DamianC

Hi Using dataflows to load data from one SQL table to another (seperate databases;...

Questions about Always On

By onlo

Dear all, I have the following questions about SQL Server Always On: How does...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers