concatenate dates for two distinct cases Sql flight 1 Manish_SQL_11_dec Solution 1 Names MC170402209 Student WORK Update using a temp table Student