if OBJECT_ID('tempdb..#t') is not null
	drop table #t
go

Create table #t (co1 int, col2 varchar(10), col3 datetime)
go

Insert into #t
Values
(1, 'test1', CURRENT_TIMESTAMP),
(2, 'test2', DATEADD(day, 1, CURRENT_TIMESTAMP)),
(3, 'test3', DATEADD(day, -1, CURRENT_TIMESTAMP))

Select [value] from 
(
	Select tt.nn.value('(.)[1]', 'nvarchar(max)') [value]
	,ROW_NUMBER() over (order by 1/0) N 
	from 
	(Select * from #t
		for xml path('root'), type
	) t(n)
	cross apply t.n.nodes('/root/*') tt(nn)
) ttt
Where N % 3 = 2