WITH UpdateList_view AS ( SELECT TOP 1 * from TX_Master_PCBA WHERe SERIAL_NO IN ('0500030309') ORDER BY TIMESTAMP2 DESC )update UpdateList_view set TIMESTAMP2 = '2013-12-12 15:40:31.593'
WITH UpdateList_view AS ( SELECT TOP 1 * from TX_Master_PCBA WHERe SERIAL_NO IN ('0500030309') ORDER BY TIMESTAMP2 DESC )update UpdateList_view set TIMESTAMP2 = '2013-12-12 15:40:31.593'