In case of SQL Server 2008 R2, and maybe earlier versions as well, the earliest date we're able to store is 1753-01-01. Is there any work around to store dates earlier than this ? Please advise. Thanks !
We store them in a dimension in our data warehouse as key value of "yyyymmdd", and then split the columns as date pieces. So, any row would have KeyVal Year Month Day 20130308 2013 03 08 20130307 2013 03 07