1.数据准备
create table SalesOrderHeader
(
SalesPersonID varchar(50),
SalesOrderID varchar(50),...','20200330')
,('02','20200330002','20200330')
,('02','20200331001','20200331')
2.使用
-- Define the CTE..., which returns sales quota data by year for each sales person....LastName nvarchar(40) NOT NULL,
Title nvarchar(50) NOT NULL,
DeptID smallint NOT NULL,
ManagerID...N'Bradley', N'Marketing Manager', 4, 273)
,(23, N'Mary', N'Gibson', N'Marketing Specialist', 4, 16);
2.递归使用演示