SELECT LeftColOuter.SerialNo AS LeftSerial, LeftColOuter.Name AS LeftName, RightColOuter.SerialNo AS RightSerial, RightColOuter.Name AS RightName FROM (
SELECT LeftCol.SerialNo, LeftCol.Name, ROW_NUMBER() OVER (ORDER BY LeftCol.SerialNo) AS RowNum FROM
(
SELECT SerialNo as SerialNo, Name as Name, ROW_NUMBER() OVER (ORDER BY SerialNo) as RowNum FROM Test
) AS LeftCol
WHERE RowNum % 2 = 1
) AS LeftColOuter
LEFT JOIN
(
SELECT RightCol.Name, RightCol.SerialNo, ROW_NUMBER() OVER (ORDER BY RightCol.SerialNo) AS RowNum FROM
(
SELECT SerialNo as SerialNo, Name as Name, ROW_NUMBER() OVER (ORDER BY SerialNo) as RowNum FROM Test
) AS RightCol
WHERE RowNum % 2 = 0
) AS RightColOuter ON LeftColOuter.RowNum = RightColOuter.RowNum
1 回答
有两个Tablix具有相同大小的动态行是不可能的 . 根据您的使用情况,您可以做的是使用设计器使用一个看似两个单独的Tablix的Tablix .
您可以使用SQL创建适合您需求的数据集 .
这将创建下表