This script utilizes this Format Date Function to sort results based on a day of the week. The case statement in this query is easy to update if your region has a different day for the start of the week. This particular script is part of a metric that I…
Category: MSSQL
MSSQL – Data Transfer
Recently I had to transfer ICD9CM codes from one database to another with limited database permissions, I decided to let the database work for me to perform the task. Ideally you’d have Visual Studio SSIS or some other mass data transfer option but this query will help you to get…
MSSQL – Identity Insert
Reference: http://technet.microsoft.com/en-us/library/aa259221(v=sql.80).aspx
MySQL – Table/View Column Information
Similar to MSSQL – Table/View Column Information, this post will help with MySQL tables and columns. This query is a quick query to give you the pertinent information about a specific table.
Ektron Alias With Folder Name
With assistance from my Ektron Content Folder Names script this script will display all aliases with the folder that the content belongs to. This is not an ideal process as you can have many folders in Ektron but this can help.
Form Action Page
This page will walk you through how to build one action page to handle various forms. WORK IN PROCESS! Form HTML fields should start with “form_” for this to work.