Just plug this into your Query Analyser and play. This code is an easier way of converting currency to English which can be altered easily to suit your needs.I found that this script will help in avoiding the storage of Amount in Words everytime an amount is stored in applicatons that require the functionality.
2006-03-27 (first published: 2006-02-21)
420 reads
This script returns the main properties for all data files and log files in the current database including logical and physical file names, size, used space, and file growth parameter.
2006-03-24 (first published: 2006-02-25)
624 reads
A common problem in sql is how to calculate and process, for the current row, information that is based on the results (sum, product, difference, etc) of the rows read so far.A solution (we use) to this problem is to create a self join query based on the primary key using the condition of "greater […]
2006-03-23 (first published: 2006-03-02)
455 reads
This is an improved and expanded version of the previously posted script that moves indexes to a new file group. This version will:1. Create new filegrup and files for indexes2. Script out and recreate indexes on new drive3. NEW* output report to text file4. NEW* Will run with enclosed wrapper for ALL DATABASES ON THE […]
2006-03-22 (first published: 2006-03-02)
2,051 reads
Inspired by the script printing c# properties. Made more general.Reuires UDF (it is included).exec vbProp 'Employee'
2006-03-20 (first published: 2006-03-06)
178 reads
this script will generate CREATE index statements for all indexes in the database;there are already scripts out there that script constraints for primary keys and unique constraints, which automatically create an index behind the scenes. but what about the other indexes?uncomment two statements in order to filter out primary keys and Unique indexes so you […]
2006-03-17 (first published: 2006-03-07)
30,757 reads
2006-03-16 (first published: 2004-09-29)
230 reads
SQL Function to calculate number of business seconds between 2 datetime fields. Input Parameters: @startdate - Start Time (datatype DateTime) @enddate - End Time (datatype DateTime) @starthour - Start of Business Day (datatype DateTime) (Format: '1900-01-01 9:00:00') @endhour - End of Business Day (datatype DateTime) (Format: '1900-01-01 17:00:00') @workdays - Business Day string - Use […]
2006-03-15 (first published: 2005-01-17)
258 reads
This version uses the Sieve of Eratosthenes algorithm, which is very fast for moderate upper bounds, but which may be slower than the other versions when the upper bound is very large (because of the overhead of the initial table population)
2006-03-14 (first published: 2003-12-17)
133 reads
This scalar udf takes three parameters @Number INT, @Length INT, @Position CHAR(1) and returns a VARCHAR(50) string which pads @Number with zeros to the specified @Length either to the right or to the left, according to @Position ('L' or 'R').E.g. SELECT dbo.udf_PadNumber(5, 6, 'L') returns '000005' whereas SELECT dbo.udf_PadNumber(5, 6, 'R') returns '500000'. The function […]
2006-03-13 (first published: 2004-08-25)
175 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers