在选择列表中是没有用EXISTS引入子查询时，可以指定只有一个表达式
INSERT INTO [dbo].[dm_pmp_scores]
([fosid],[fycode],[empid],[fullname],[jobgrade],[meritrate],[perfrate],
[potband],[hrremarks],[isdirty],criticality,promotability,PostRanking,iscommited)
select '75DA940A-5436-4866-8D44-FE1890E2C0F6','FY0607','tt0042',
(select distinct fullname,jobGrade from [vw_pat_users] where EmployeeID='tt0042'),'A','B','Band 2','','0','','','',0


报错
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

[解决办法]
select distinct fullname,jobGrade from [vw_pat_users] where EmployeeID='tt0042'得到的是一个集合 所以有问题

这样的赋值只能是单个的值。
[解决办法]

SQL code

INSERT INTO [dbo].[dm_pmp_scores]  ([fosid],[fycode],[empid],[fullname],[jobgrade],[meritrate],[perfrate],[potband],[hrremarks],[isdirty],criticality,promotability,PostRanking,iscommited)  select distinct '75DA940A-5436-4866-8D44-FE1890E2C0F6','FY0607','tt0042', fullname,jobGrade ,'A','B','Band 2','','0','','','',0from [vw_pat_users] where EmployeeID='tt0042'