摘要：
SELECT[EmpTemplateHistoryID],[EmployeeID],[TemplateID],[AdjustStatus],[AdjustReason],[AdjustTime],isnull((select top 1 [EmpTemplateHistoryID] from [EmpPRTemplateHistory] where [EmployeeID]=a.EmployeeID),NEWID()) [AdjustBeforeHistoryID],[Remark],getdate()FROM @DataTable awhere NOT EXISTS(SELECT * FR. 阅读全文
posted @ 2012-06-15 15:27
万德源
阅读(244)
评论(0)
推荐(0)
浙公网安备 33010602011771号