Question

SQL数据库中，创建一个视图，怎么把前面原始表中的数据呈现出后面的格式呢？

Answer 1

把tableName换成你的表名。数据库必须是sql2005或以上版本。
下面见证神一样的SQL：
SELECT
(
select stb from (SELECT ROW_NUMBER() over(order by getdate()) as id,* FROM tableName) as c where c.id = (
select MAX(b.id)
from (SELECT ROW_NUMBER() over(order by getdate()) as id,* FROM tableName) as b
where b.id< aa.id and SUBSTRING(stb,0,2)='#')
) as 客户编号 ,aa.stb as 货号
FROM (SELECT ROW_NUMBER() over(order by getdate()) as id,* FROM tableName)as aa
where substring(stb,0,2) <> '#'

Answer 2

这个有难度。
要用临时表和游标来一行一行处理。SQL 2005/2008 支持表达式，你可以试试看。

Answer 3

可以转换为xml，然后循环出来就好了