;WITH jls
AS
(
SELECT ROW_NUMBER ( ) OVER ( PARTITION BY date ORDER BY date ) AS RN
, *
FROM #tmp
WHERE (seqno IS NULL)
)
select * from jls where RN %2 = 0
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day