Useful, dynamically-generated dates for SQL Server.
SQL Server: Date Arithmetic
Leave a reply
Tag Archives: SQL Server
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.
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.
Business Objects Enterprise: Create a Dynamic List of Date Ranges
Add a dynamic, date-range parameter to a report which includes the most recent 12 months, plus Crystal Reports’ Month-to-Date and Year-to-Date ranges.
