quote:

---

Originally posted by jezemine

if you have a column with a rownumber value in it, you can use the mod operator to do this.

That is:

declare @t table (id int)
insert into @t
select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6 union all
select 7 union all
select 8 union all
select 9

select * from @t where (id + 2) % 3 = 0

if you don't have a rownumber column, see this article:
http://www.sqlteam.com/item.asp?ItemID=1491

---

SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org

---

declare @t table (id int)
insert into @t 
select 1 union all
select 23 union all
select 53 union all
select 342 union all
select 232 union all
select 5332 union all
select 13 union all
select -234 union all
select 0


select id, case when orderby % 3 = 0 then 'third' else '' end position from (
select t.*, (select count(*)  from @t x where x.id < t.id) orderby
from @t t) q
order by orderby