求分页SQL语句

[chengduforest]

按某列BillID进行分页的SQL语句如下：

Select top XX BillID,OrderDate from dtSaleOrder

where BillID not in (Select top XX BillID from dtSaleOrder Order by BillID )

Order by BillID

以上是按一列进行分页，请教如果要按两列，例如BillID+OrderDate进行分页，上面的SQL语句该如何改写？

[chengduforest]

自顶一次

[yaoyaogghaha]

declare @pagesize int,@page int,@SQLString varchar (8000)
set @pagesize=10
set @page=2
set @SQLString=''
set @SQLString=@SQLString + 'select top '+cast(@pagesize as varchar(10)) +' BillID +''-''+OrderDate from dtSaleOrder '
set @SQLString=@SQLString + ' where BillID not in (select top '+cast(@pagesize*(@page-1) as varchar(10))+' BillID from dtSaleOrder order by BillID ) '
set @SQLString=@SQLString + ' order by BillID '
exec (@SQLString)

[chengduforest]

谢谢楼上的DX，不过我要的是SQL语句，不是存储过程

[yaoyaogghaha]

Select top xx cast(BillID as varchar(100))+'-'+cast(OrderDate as varchar(100)) from dtSaleOrder
where BillID not in (Select top xx BillID from dtSaleOrder Order by BillID )
Order by BillI

[chengduforest]

可能我没写清楚，要Select出来的列不是BillID+OrderDate的合并列，而是BillID和OrderDate两列