需要查询以使用select语句添加自定义行.

本文介绍了需要查询以使用select语句添加自定义行.的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有2张这样的桌子.

I have 2 tables like this.

推荐答案

尝试此操作 Try this DECLARE @ENameTable AS Table (ECode BIGINT, EName NVARCHAR(50)) DECLARE @ManagerTable AS Table (ECode BIGINT, ManagerName NVARCHAR(50)) INSERT INTO @ENameTable SELECT 1,'Ram' UNION SELECT 2,'Shayam' UNION SELECT 3,'Hari' UNION SELECT 4,'Joseph' UNION SELECT 5,'Abdul' INSERT INTO @ManagerTable SELECT 1,'Peter' UNION SELECT 2,'Mac' UNION SELECT 3,'Mac' UNION SELECT 4,'Peter' UNION SELECT 5,'Peter' SELECT First_Col,Sec_col FROM ( SELECT 1 rwid,ManagerName First_Col, ManagerName + CAST(COUNT(ManagerName) AS NVARCHAR(10)) Sec_col FROM @ManagerTable GROUP BY ManagerName UNION ALL SELECT 2 rwid ,M.ManagerName First_Col,E.EName Sec_col FROM @ENameTable E Inner Join @ManagerTable M ON E.ECode=M.ECode ) AS TBLE ORDER BY First_Col,rwid