select top 100 ID,Code,Name,CreatedOn,ModifiedOn
into #bb
from CBO_ItemMaster
SELECT ID , Name , ( SELECT MAX(LastUpdateDate) FROM ( VALUES ( CreatedOn), ( ModifiedOn)) AS UpdateDate
( LastUpdateDate ) ) AS LastUpdateDate FROM #bb
into #bb
from CBO_ItemMaster
SELECT ID , Name , ( SELECT MAX(LastUpdateDate) FROM ( VALUES ( CreatedOn), ( ModifiedOn)) AS UpdateDate
( LastUpdateDate ) ) AS LastUpdateDate FROM #bb