求这个怎么查询，就是当客户的下一个值是ＮＵＬＬ，则认为后面的物料和单价是这个客户的，得到右边的表

[搭边的日月]

[搭边的日月]

如图

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(
    客户 NVARCHAR(10),
    物料名称 NVARCHAR(10),
    成交额 INT
)
GO
SET NOCOUNT ON
INSERT INTO t VALUES ('a','wl',200)
INSERT INTO t VALUES (NULL,'wl1',100)
INSERT INTO t VALUES ('b','wl3',100)
INSERT INTO t VALUES (NULL,'wl1',300)
INSERT INTO t VALUES ('a','wl5',10)

;WITH cte AS (
	SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS rid,* FROM t
),cte2 AS (
	SELECT 
		CASE WHEN 客户 IS NULL THEN (SELECT TOP 1 客户 FROM cte AS b WHERE b.rid<a.rid AND b.客户 IS NOT NULL ORDER BY rid DESC) 
		ELSE 客户 END
		AS 客户
		,物料名称
		,成交额 
	FROM cte AS a
)
SELECT * FROM cte2
ORDER BY 客户

[吉普赛的歌]

引用 3 楼 qq_43381622 的回复:

多谢版主，版主真牛！

不客气， 没事就结贴吧

[搭边的日月]

多谢版主，版主真牛！