The Query Needs to populate Most recent Data and time of the values Captured in those Fields.

SELECT t.column1,t.column2,..,MAX(t1.CallBackTm) AS LatestCallBackTime
FROM YourTable t
CROSS APPLY (VALUES (CallBack1DateTime),(CallBack2DateTime),(CallBack3DateTime),(CallBack4DateTime),(CallBack5DateTime))t1(CallBackDtTm)
GROUP BY t.column1,t.column2,.. (all columns in your main table)

In case you want value to be updated back to table then use this

UPDATE t
SET LatestCallBakTime = LastCallBackTime
FROM Table t
INNER JOIN (SELECT PK,
            MAX(CallBackDtTm) AS LastCallBackTime
            FROM Table t1
            CROSS APPLY (
                         VALUES (CallBack1DateTime),
                         (CallBack2DateTime),
                         (CallBack3DateTime),
                         (CallBack4DateTime),
                         (CallBack5DateTime)
                        )t1(CallBackDtTm)
            GROUP BY t.PK)t1
            ON t1.PK = t.PK

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c