|
|
Posted by Alexander Kuznetsov on 05/06/06 00:36
Erland,
There is another approach, you can number days sequentially, such as
datediff(day, '20000101', your_original_date). In many cases it allows
to use a 2-byte integer, and that may be quite a difference. I use
dateadd to get dates from those integers, but but dates are needed for
display purposes only, not frequently. I also use a calendar table with
the the same integer as PK.
Navigation:
[Reply to this message]
|