Create Date Table
-
Posted on June 17, 2009 by Derek Dieter
create table dates(
id int not null,
[date] as (yyyy+mm+dd),
yyyy char(4) not null,
mm char(2) not null,
Featured Articles
- How to cache stored procedure results using a hash key There are a lot of different design patterns that lend themselves to creating
- SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
- Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
- Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.
Site Author
