This Sql Server script will create a function that returns all dates in a date range as a table.
SQL Server: Create a Table of Dates
Leave a reply
Category Archives: Programming
Crystal Reports: ElapsedTime() Function
Converts a number of seconds into a string in the format of days.hours:minutes:seconds.
Oracle: Object Dependencies
This article demonstrates a SQL query that lists Oracle views and functions and the functions and tables that are contained in them.
Crystal Reports: ShellSort() Function
Sort an array of numbers using the Shell sort algorythm. This sorting algorythm will quickly sort arrays in Crystal Reports.
Crystal Reports: FirstDayOfPrevMonth() Function
Crystal Reports custom function to calculate the first day of the prior month.
Crystal Reports: DateTimeToJulian() Function
Convert a VB Script DateTime to a Julian date
Oracle: FAQ
Crystal Reports: DecimalToFraction() Function
Oracle: Find column or table query
Search all Oracle tables for a specific column or table name.
Crystal Reports: ElapsedTime Function
Calculates the difference between two dates in Days.Hours:Minutes:Seconds format.