Determines if a string value is contained in an array of strings.
Crystal Reports: Display a Message When Report Has No Data
Often it is desirable to display a message, such as ‘No matching records’, when a report does not contain data. Unfortunately, Crystal Reports does not have a function to easily identify this state.
Crystal Reports: Common Files Directories
The location of the Crystal Reports ‘Shared’ directory has changed over time. When deploying applications that use Crystal Reports, ensure that exporting, user-function library (UFL), and database DLLs are located in the appropriate directory for the version of Crystal Reports that is being used. Continue reading
SQL Server: Greater() Function
A SQL Server, scalar-value function that returns the greater of two dates.
SQL Server: Lesser() Function
A SQL Server, scalar-value function that returns the lesser of two dates.
SQL Server: Import DTS Packages using a Script
Use a VB Script file to import .DTS files into the local Sql Server database.
Outlook: Export Contacts to vCards
This script will export all Outlook Contacts as vCards. Continue reading
Visual Basic: Convert a Windows AD account name to a 'real' name.
Convert a Windows AD account name to the individual’s actual name, using ADSI.
Sql Server: DateRanges() Function
This user-defined function creates a table of date ranges. Continue reading
Sql Server: GetNow View
The Sql Server GETDATE() function not allowed in the body of user-defined functions, as it is non-deterministic. The GetNow view provides a means to generate a system date/time that can be used in Sql Server user-defined functions.