michaelm-746562 (2/27/2012)
Additionally, I use an integer field in the table to allow queries easily to span segments that include differing years. The integer opens the door to arithmetic operations for query construction.Example:
SequenceNumber TimeKey
11 201111
12 201112
13 201201
14 201212 & C.
Sorry for the late response but I lost track of this thread. A recent post to it "found" it for me.
What kind of "arithmetic operations" have you actually used against that column and what do they do?
--Jeff Moden
Change is inevitable... Change for the better is not.