ACCESS
SELECT (
SELECT count(*)+1 as dd
FROM tSalaryRep as a where a.fid>b.fid) AS bb, b.fid
FROM tSalaryRep AS b
ORDER BY b.fid DESC;
SQL SERVER
select identity(int,1,1) as ID,* into #Temp from TalbeName
select * from #Temp
SELECT (
SELECT count(*)+1 as dd
FROM tSalaryRep as a where a.fid>b.fid) AS bb, b.fid
FROM tSalaryRep AS b
ORDER BY b.fid DESC;
SQL SERVER
select identity(int,1,1) as ID,* into #Temp from TalbeName
select * from #Temp