Useful, dynamically-generated dates for SQL Server.
Useful, dynamically-generated dates for SQL Server.
A SQL Server, scalar-value function that returns the greater of two dates.
A SQL Server, scalar-value function that returns the lesser of two dates.
Use a VB Script file to import .DTS files into the local Sql Server database.
This user-defined function creates a table of date ranges. Continue reading
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.
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.