TAG | SQL Server
5
SQL Server: Date Arithmetic
No comments · Posted by Craig Buchanan in Programming, SQL, SQL Server, Technique
Useful, dynamically-generated dates for SQL Server. (more…)
Date · Programming · SQL · SQL Server · T-SQL
26
SQL Server: MaximumDate() Function
No comments · Posted by Craig Buchanan in Programming, SQL Server
A SQL Server, scalar-value function that returns the greater of two dates. (more…)
26
SQL Server: MinimumDate() Function
No comments · Posted by Craig Buchanan in Programming, SQL Server
A SQL Server, scalar-value function that returns the lessor of two dates. (more…)
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.
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.
24
Business Objects Enterprise: Create a Dynamic List of Date Ranges
4 Comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, SQL Server, Technique
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.
Business Objects · Business View · Crystal Reports · Date/Time · Parameters · SQL Server
