如何才能让identity的顺序与我的ORder by顺序相同?
原来数据
SortID Quality
-------------------------
3 B333B
4 A334B
7 A334A
8 K334B
9 K334A
10 K334K
13 W334B
18 W334A
19 W334K
我想得到如下的临时表
SortID Quality idd
-------------------------
3 B333B 1
4 A334B 2
7 A334A 3
8 K334B 4
9 K334A 5
10 K334K 6
13 W334B 7
18 W334A 8
19 W334K 9
用如下SQL语句得到的结果
SELECT d.SortID, d.Quality, idd=identity(int,1,1)
INTO #a
FROM dbo.Q_SaleQuoteDetail d
ORDER BY d.SortID
select * from #a Order by idd
drop table #a
SortID Quality idd
-------------------------
7 A334A 1
4 A334B 2
3 B333B 3
9 K334A 4
8 K334B 5
10 K334K 6
18 W334A 7
13 W334B 8
19 W334K 9
问题：如何才能让identity的顺序与我的ORder by顺序相同?
[解决办法]
--先创建临时表
create table #a(SortID int, Quality varchar(100), idd int identity(1,1))
insert into #a(SortID,Quality)
SELECT d.SortID, d.Quality
FROM dbo.Q_SaleQuoteDetail d
ORDER BY d.SortID
select * from #a Order by idd
drop table #a
