CAT | Programming
16
SQL Server: Import DTS Packages using a Script
1 Comment · Posted by Craig Buchanan in Programming, SQL Server
Use a VB Script file to import .DTS files into the local Sql Server database.
9
Outlook: Export Contacts to vCards
1 Comment · Posted by Craig Buchanan in Outlook, Programming
This script will export all Outlook Contacts as vCards. (more…)
COM · Contacts · Outlook · Programming · vCard · Visual Basic
14
Visual Basic: Convert a Windows AD account name to a 'real' name.
No comments · Posted by Craig Buchanan in Programming, Visual Basic
Convert a Windows AD account name to the individual’s actual name, using ADSI.
25
Sql Server: DateRanges() Function
No comments · Posted by Craig Buchanan in Functions, Programming, SQL Server
This user-defined function creates a table of date ranges. (more…)
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.
25
Crystal Reports: CDateRange() Function
No comments · Posted by Craig Buchanan in Functions, Programming
Convert a string value into its equivalent Date Range.
14
Crystal Reports: getLocalizedString() Function
2 Comments · Posted by Craig Buchanan in Functions, Programming
getLocalizedString is a Crystal Reports Custom Function to used convert a constant to a localized string.
8
Crystal Reports: FirstMonday() Function
No comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Finds the the first Monday in the current month.
8
Crystal Reports: Pad() Function
1 Comment · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Adds the specific character to the left side of a value when the value is less than a comparison. Useful when converting a single-digit month or day to a string.
6
Visual Basic: Generate a List of Installed COM Compontents
No comments · Posted by Craig Buchanan in Programming, Visual Basic
It is often useful to see a list of installed COM components on a given machine. The Component Explorer uses the registry and Microsoft’s Typelib component to generate this list.
No tags
