sqlserver 拷贝同步多个表数据到另一张表

最新推荐文章于 2024-11-20 14:26:58 发布

weixin_30809173

最新推荐文章于 2024-11-20 14:26:58 发布

阅读量502

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/min-min-min/p/6362759.html

本文提供了一个SQL脚本示例，展示了如何从一个业务绩效表（Business_DMS_Performance）和员工表（Business_DMS_Employees）中选择特定记录，并将其插入到另一个绩效评估表（Business_DMS_PerformanceEvaluate）中。

--/****** Script for SelectTopNRows command from SSMS ******/

Insert into [DMSBusiness].[dbo].[Business_DMS_PerformanceEvaluate]
( [SystemCreateDate]
,[SystemCreator]
,[SystemParentID]
,[SystemFormStatus]
,[Year]
,[Quarty]
,[PerformanceEvaluateLevel]
,[PerformanceEvaluate]
,[DirectSupervisor]
,[DecisionMakingSupervisor])
select [SystemCreateDate]
,[SystemCreator]
,[ID]
,[SystemFormStatus]
,[PerpormanceYear]
,[PerformanceSeason]
,[FinalRate]
,[Comment]
,[SeasonDirector]
,[SeasonPolicymakers] //字段相对应；赋值关系
from (
SELECT c.[ID]
,a.[SystemCreator]
,a.[SystemCreateDate]
,a.[PerformanceSeason]
,a.[PerpormanceYear]
,a.[FinalRate]
,a.[Comment]
,[SeasonDirector]
,[SeasonPolicymakers]
,a.[SystemFormStatus]
FROM [DMSBusiness].[dbo].[Business_DMS_Performance] as a
join (SELECT [ID],[UserId]
FROM [DMSBusiness].[dbo].[Business_DMS_Employees]) as c on a.SystemCreator=c.UserId
) d where [SystemFormStatus]=373