select a01 into #tmp from A表
union all
select a02 from A表
union all
select a03 from A表
...
union all
select a10 from A表
union all
select a02 from A表
union all
select a03 from A表
...
union all
select a10 from A表
union all
select a02 from A表
union all
select a03 from A表
...
union all
select a10 from A表
union all
select a2 from a
.....
union
select a10 from a
union all
select a02 from A表
union all
select a03 from A表
...
union all
select a10 from A表