| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A Number To Words function Version 2 | SQL Server 2000, SQL Server 7.0 | Intermediate /
Pating sa Dagat | 9245 since
5/19/2006 3:42:01 AM |
By 1 Users
|
| |
Converts a numeric value to words, i.e, 123 will return ONE HUNDRED TWENTY THREE |
| |
| |
| |
|
 Age in years and months. | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 3080 since
1/2/2013 2:30:45 PM | Unrated
|
| |
May a times were are faced with situation to find the age of person.
Below mentioned code finds the age of person in years and months.
|
| |
| |
| |
|
Base conversion 10 to N | SQL Server 2000, SQL Server 7.0, Other | Advanced /
sp | 5030 since
4/14/2008 10:18:17 AM | Unrated
|
| |
Converts a base10 numner to another base number (2-36 supported) |
| |
| |
| |
|
Base Conversion N to 10 | SQL Server 2000, SQL Server 7.0, Other | Advanced /
sp | 5266 since
4/14/2008 10:18:30 AM | Unrated
|
| |
Converts any base number (2-36) back to base10 |
| |
| |
| |
|
Calculate the number of days between a given date and the 3rd sunday of the current month | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 20578 since
7/29/2000 10:04:32 PM |
By 2 Users
|
| |
This T-SQL script shows how to calculate the number of days between a given date and the 3rd sunday of the current month. This can be easily modified to accomodate count till 3rd saturday or 3rd monday of current month & so on. |
| |
| |
| |
|
Calculating Compounded Value | SQL Server 2000 | Advanced /
Dinesh Mishra | 1793 since
11/4/2011 4:34:30 PM | Unrated
|
| |
Code to calculate the compounded Value
===================================
Often we are faced with situations wherein we want to calculate the compounded value of an invested amount at some specific rate of interest per year for some specific number of ye ...(description truncated) (ScreenShot) |
| |
| |
| |
|
Compute product of values | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Beginner /
Umachandar | 11380 since
7/25/2000 8:42:10 PM |
By 2 Users
|
| |
Determine the product of values in a column. |
| |
| |
| |
 |
 Count Integer Places & Count Fractional Places | Oracle | Advanced /
Andy Archer | 12658 since
11/8/2012 4:09:27 PM |
By 1 Users
|
| |
Without looping, these tiny PL/SQL stored functions return the number of places to the left or right of the input number's decimal point, respectively. With both-in-one version and SQL*Plus test scripts. |
| |
| |
| |
|
Decimal datatypes | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 13543 since
7/25/2000 8:41:32 PM |
By 1 Users
|
| |
How does decimal datatypes differ in their precision & scale? This example demonstrates...see my comments in the code. |
| |
| |
| |
|
Decode powers of 2 | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Intermediate /
Umachandar | 14088 since
7/25/2000 8:46:43 PM | Unrated
|
| |
decode powers of 2 as columnar values or rows. |
| |
(ScreenShot)
