根据楼上提示数据源可以设成以下形式:
select id from
(select number from master..spt_values
where [type]='P' and number<:rowcount*:n_up)t2
left join (
select id,name from (
select 1 as id,'' as name union all
select 2 as id,'' as name union all
select 3 as id,'' as name union all
select 4 as id,'' as name union all
select 5 as id,'' as name union all
select 6 as id,'' as name union all
select 7 as id,'' as name union all
select 8 as id,'' as name union all
select 9 as id,'' as name union all
select 10 as id,'' as name) t1)t1 on (t1.id-1)=t2.number
order by number%:rowcount,number
SQLServer数据库,rowcount表示行数此例中为6,n_up表示为列数此例中为2