Viewing 3 posts - 1 through 3 (of 3 total)
Any item of information that can be derived from a date could be stored in the calendar table if it simplifies or improves the performance of queries or code. ...
September 23, 2010 at 9:33 am
The article tries to cover too much ground and ends up doing none of the topics justice. In particular, the first function described would have been much better implemented...
September 23, 2010 at 1:32 am
A minor quibble on the ROW_NUMBER() examples: the ORDER BY clause is pointless since it repeats the PARTITION BY expression list. The ORDER BY list controls the order within...
September 22, 2010 at 4:06 am
Viewing 3 posts - 1 through 3 (of 3 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy