sql 合并单元格
--combine the column ToNo and column ToSName.
SELECT t.id,
TONo=CASE WHEN t.id=(
SELECT MIN(id)
FROM @TableHaveEndNumber
WHERE TONo=t.TONo
)
THEN t.TONo
ELSE '' END,
TOSName=CASE WHEN t.id=(
SELECT MIN(id)
FROM @TableHaveEndNumber
WHERE TOSName=t.TOSName
)
THEN t.TOSName
ELSE '' END,
t.startNumber,t.endNumber,t.bookStart,t.dataIssued,t.groupColumn
FROM @TableHaveEndNumber t
ORDER BY t.groupColumn,t.id