摘要:
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
万德源
阅读(236)
推荐(0)
编辑