表A
ID AMOUNT
1 -1024
2 -1000
... ...
表B
ID AMOUNT
1 1500
2 800
... ...
如何合成表C，注意顺序，同一ID是表A一条记录后表B一条记录，需要查询语句，不用存储过程逐条处理。
ID AMOUNT
1 -1024
1 1500
2 -1000
2 800
... ...
------解决方案--------------------
create table #temp
(id int,
AMOUNT varchar(10))
insert into #temp
select 1,'-1024' union
select 2,'-1000'
create table #temp2
(id int,
AMOUNT varchar(10))
insert into #temp2
select 1,'1500' union
select 2,'800'
select * from #temp
union all
select * from #temp2
order by id
------解决方案--------------------
SELECT ID,AMOUNT
FROM (SELECT *, 0 n FROM 表A
UNION ALL
SELECT *, 1 n FROM 表B
) T
ORDER BY ID,n