Viewing post 1 (of 2 total)
What about:
create table #seq
(
ID int IDENTITY(1,1),
Country_id int
)
insert into #seq
select 14 union all
select 8 union all
select 3 union all
select ....
select top 5
T.Country
from #temp1 T
inner join #seq S on T.ID = S.Country_id
where...
July 16, 2009 at 4:58 pm
#1025954