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 provide for calls that come…
Validate a non-DateTime data type field is a really a date.
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 the data across. One thing…
Reference: http://technet.microsoft.com/en-us/library/aa259221(v=sql.80).aspx
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.
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.
Related Queries: Ektron Alias With Folder Name
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.