| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Olap Date Dimension Builder | SQL Server 7.0, Oracle, Other | Beginner /
Javier Pichot | 10436 since
7/12/2002 3:42:55 PM |
By 1 Users
|
| |
An access database, with a day table, and a script to generate de Date dimension used in any datawarehouse cube. Once generated, you can export to any DB Engine. |
| |
| |
| |
|
Pivot Table Creation in SQL SERVER 2005. | SQL Server 2000 | Advanced /
Dinesh Mishra | 6096 since
7/25/2010 9:14:23 AM | Unrated
|
| |
Creation of Pivot always makes it easy to read data and make conclusions fast. It is one of strong points of Microsoft Excel Spreadsheet. It is easily understood by everyone and needed frequently in various scenarios. Eveb Sql Server 2005 is capable of cr ...(description truncated) |
| |
| |
| |
|
 Redirect PL/SQL script to a bat file | Oracle, Other | Beginner /
Mike J Anderson | 11719 since
1/9/2002 8:03:00 PM |
By 2 Users
|
| |
If you create bat files you can re-direct your SQL script into the bat file then call the bat file via an external application (Example: VB) |
| |
| |
| |
|
REGEXP usage in MySQL | Other | Intermediate /
deejay © | 5126 since
9/5/2003 7:34:58 AM | Unrated
|
| |
How to use regular expressions with MySQL |
| |
| |
| |
|
Retrieve All Table Names from a Schema | Oracle | Advanced /
Mike J Anderson | 8216 since
1/9/2002 8:25:28 PM |
By 2 Users
|
| |
Fetches all the table names in a schema. Can then be uses in a redirect w/ a desc. |
| |
| |
| |
|
Slowly Changing Dimension1(SCD Type1) | Oracle | Advanced /
rupeshvin | 2717 since
3/2/2006 10:42:24 AM | Unrated
|
| |
In Datawarehouse Industry Slowly Changing Dimension Is widely used |
| |
| |
| |
 |
 Using TRY...CATCH in Transact-SQL | Other | Intermediate /
Himanshu Kumar Sinha | 8707 since
10/26/2005 2:15:56 AM | Unrated
|
| |
I will discuss the new feature ( TRY ........CATCH) for errorhandling in SQL SERVER 2005 |
| |
| |
| |
|
View DTS Logs | SQL Server 7.0, Other | Advanced /
Ramdas Narayanan | 8032 since
10/31/2001 6:04:29 PM |
By 2 Users
|
| |
To view the logs of a DTS package. It also shows the time elapsed for each step in the DTS package |
| |
| |
| |
|
Visual Basic Data Mining With Naïve Bayes Version 2.0 New Release | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Oracle, Other | Intermediate /
User Interface Developers | 7479 since
10/2/2002 1:48:52 AM | Unrated
|
| |
October 1, 2002: visual-basic-data-mining.net is pleased to announce the release of their visual basic data mining application.
Developed with Visual Basic 6, Visual Basic Data Mining With Naïve Bayes Version 2.0 Release is designed for data mining on re ...(description truncated) (ScreenShot) |
| |
| |
| |
|
XML for Analysis Browser | SQL Server 2000 | Advanced /
Igor Krupitsky | 8180 since
8/29/2005 10:11:57 PM |
By 1 Users
|
| |
This browser can access a Microsoft Analysis Services Cube over the Internet. It requires no client side software other the Internet Explorer 5 or higher. This browser takes advantage of the XML for Analysis SDK
OWC (Office Web Components), on the other h ...(description truncated)(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
