The idea is to perform data cleansing on the Date and Time field from different formats into a unify format such as: YYYYMMDD. Here is a sample data to be used for the data cleansing that I will perform below...
SQL 2012 or higher - Processing hundreds of millions records can be done in less than an hour. Processing hundreds of millions of records requires a different strategy and the implementation should be different compared to smaller tables with only several millions of records.