| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Dollars And Cents To English | Oracle | Advanced /
Andy Archer | 22854 since
3/16/2007 2:40:59 PM | Unrated
|
| |
This PL/SQL stored function returns the English language translation of the dollars and cents input. (Range: -999999999999999.99 through 999999999999999.99). |
| |
| |
| |
 |
Factorial Calculator. | SQL Server 2000 | Intermediate /
Dinesh Mishra | 4805 since
6/11/2010 8:06:11 AM | Unrated
|
| |
For calculating Factorial. |
| |
| |
| |
|
 find the greatest circle distance | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 8220 since
7/27/2000 9:19:15 PM | Unrated
|
| |
How to find the greatest circle distance. Also shows how to do a simple UPDATE loop. Note that the greatest circle formula is an approximation only. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Finding the argument of a given Complex Valued Column | SQL Server 2000, SQL Server 7.0 | Advanced /
barkýn ünüulu | 4864 since
4/11/2007 7:30:38 AM | Unrated
|
| |
The purpose of this code is to find the argument of a given complex valued attribute on a given mathematical database. |
| |
| |
| |
|
fn_NumberOfLays | SQL Server 2000 | Advanced /
John C Kirwin | 4194 since
1/7/2006 8:02:16 PM | Unrated
|
| |
Used to calculate the number of times to lay fabric based on cut type. (ScreenShot) |
| |
| |
| |
|
Format int or decimal values with commas | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 11033 since
7/25/2000 8:38:04 PM | Unrated
|
| |
Format int or decimal values with commas. This will work only for the range of values between those of the MONEY datatype. See CONVERT help for other styles.
|
| |
| |
| |
|
Format integer strings (Function & SP) | SQL Server 7.0, Other | Beginner /
MisterD88 | 22444 since
10/8/2001 7:05:34 PM |
By 4 Users
4 Excellent Ratings
|
| |
Formats a string representing a numeric or decimal value, to an input length of 6000 characters, and adds commas after every set of three numbers, on all values to the right of the decimal (if any) basically it takes a sting such as '1234567890.123' and r ...(description truncated) |
| |
| |
| |
|
Format Number | Oracle | Beginner /
Andy Archer | 10486 since
11/8/2012 4:09:29 PM |
By 2 Users
|
| |
This tiny PL/SQL stored function, on a TO_CHAR of in_number, replaces the significant-digit format model's comma with any character (or characters) of your choosing, returning the formatted number as varchar2. With SQL*Plus test script. |
| |
| |
| |
|
Format Number field | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Edwin Cadthuz | 3238 since
10/9/2007 2:09:42 PM |
By 1 Users
|
| |
When you migrate from Ms-Access to MS-SQL this function will help you to retain your old query strings by just replacing 'format' keyword with 'master.dbo.spxNumber' |
| |
| |
| |
|
FORMATTING NUMBERS IN SQL SERVER | SQL Server 2000, SQL Server 7.0 | Advanced /
barkýn ünüulu | 16899 since
10/6/2007 7:08:53 PM | Unrated
|
| |
The Purpose of this function is to develop a function that formats the given number in a dotted format. For example given 1000000, the function will return 1.000.000 |
| |
(ScreenShot)
