Hi this is my first post here at SQLServer Performance. Wondered if anyone could help: I have a database from 2009 with a bunch of test data. I want to replace all the date/time fields in the source data with current dates - so that the year is updated to 2012. The context is that I'm loading this data via SSIS into weekly partitions into a data mart. I created the data mart partitions from todays date. and do not want to create partitions going back to 2009. What's the syntax for replacing all the 2009's in every Date/Time field in the entire database with 2012's?