SQLServerCentral - Scripts by Joshua A. Walker

Three functions for obtaining the date and time dimension keys with a date or the date from the keys Read more...

By Joshua A. Walker 2009/03/12 | Source: SQLServerCentral.com | Category: Data Warehousing

Rating:

|

Briefcase | 1,518 reads

Very simple function code to add leading zeros to a passed in int for a length also passed. Read more...

By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: Data Warehousing

Rating:

|

Briefcase | 1,105 reads

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving. Read more...

By Joshua A. Walker 2009/02/18 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Briefcase | 1,056 reads

Will find the Table Name, Column Name and the number of occurances some text appears in a database. Read more...

By Joshua A. Walker 2009/02/24 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Briefcase | 3,471 reads

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects. Read more...

By Joshua A. Walker 2009/02/19 | Source: SQLServerCentral.com | Category: Stored Procedures

Rating:

|

Briefcase | 1,019 reads

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script. Read more...

By Joshua A. Walker 2009/02/13 | Source: SQLServerCentral.com | Category: Data Warehousing

Rating:

|

Briefcase | 5,640 reads