Have you ever wanted to spell out a number as words , perhaps for reporting / automated form filling ? This script / UDF takes some cues from the various scripts out there, however they didn't cover numbers beyond a billion, decimal places beyond two, and often appended currency names... Read more
When transferring tabular data from excel or csv into an SQL table you can run into truncation issues, this is usually due to SQL's importer only testing a few rows and predicting max field length, which can throw errors later on in the script. For small ( less than 1m... Read more
The blog crashed, and the database corrupted. A harsh lesson has been learned about keeping backups of the database. This is version 2. Watch this space!... Read more
