update [QualityControl].[dbo].[T_ControlLog] set [ResultByControl]='2',
[QaRemarks] = case when [QaRemarks] is null then '第二次质检修改' else [QaRemarks]+'第二次质检修改' end
where [EmployeeByMarket]='3369' and [MarketDate]>'20121023' and [MarketDate]<'20121024'
and [ResultByControl]='1'
[QaRemarks] = case when [QaRemarks] is null then '第二次质检修改' else [QaRemarks]+'第二次质检修改' end
where [EmployeeByMarket]='3369' and [MarketDate]>'20121023' and [MarketDate]<'20121024'
and [ResultByControl]='1'