Binaryworld - Display every Nth record. ... [ SQL Server -> T-SQL ]

--//Script to display every nth record from table
--//Create test table
if OBJECT_ID('myTable') IS NOT NULL
DROP TABLE myTable
go

create table myTable
(
field1 int
,field2 char(4)
)
go
Insert into myTable(field1,field2) Values(001,'aaaa')
Insert into myTable(field1,field2) Values(101,'bbbb')
Insert into myTable(field1,field2) Values(201,'dfdf')
Insert into myTable(field1,field2) Values(301,'sfsf')
Insert into myTable(field1,field2) Values(401,'dgfg')
Insert into myTable(field1,field2) Values(501,'hjjh')
Insert into myTable(field1,field2) Values(601,'45rf')
Insert into myTable(field1,field2) Values(701,'fhhh')
Insert into myTable(field1,field2) Values(801,'ghhn')
Insert into myTable(field1,field2) Values(901,'gfhh')

go

declare @n int
--/////////////////////////////////////

set @n=3 --//Display every 3rd record

--/////////////////////////////////////

SELECT
IDENTITY (int, 1, 1) As Rank --//Generate sequencial number
,t.*
INTO #tmp
FROM dbo.myTable t--dbo.tmpRenewNotes

--//Display result
select * from #tmp where rank % @n = 0

drop table #tmp