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

89 reads

Blogs

The T-SQL Tuesday Corollary

By

T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics...

How to Import Perfmon Data into a SQL Server for Analysis

By

If you followed the last video, I showed you how to set up windows...

How To Set Up Perfmon for 24×7 Collection

By

I just released a new training video (one of many to be released in...

Read the latest Blogs

Forums

OLAPQueryLog does not work for SSAS Tabular mode

By Tho Le

I running into a problem when I try to setup querylog in SSAS. The...

Code to auto-update tables on set date

By thetubageek

I am in a project where information is being pulled from a database then...

Required Environment Variables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Required Environment Variables

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers