K. Brian Kelley - Tuesday, January 30, 2018 11:21 AM
I would just use the date itself. It's only a single field instead of being a composite key. It's more human readable. I could see having an index on year/day of the year, but I would not make it the PK.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA