Tag Archives: dates

Populate SQL Table with All Valid Dates Between Two Periods

I am working on a request from a client that required the use of a date table, but not just any date table. This table had some additional requirements; 1. …

Tags: , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started …

Tags: , , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Set Expiration Dates on Web Assets

If you have been following any of my articles you will know that I am always looking for ways to improve performance. Nothing is more frustrating than to go to …

Tags: , , , , , , , , | Posted under ASP .NET 4.0, Programming/Coding | Leave a comment