Paging for pedigree extraction - Horse Paging 2/3

 
/****** Object:  StoredProcedure [dbo].[HorsesPaging2]    Script Date: 10/31/2009 13:03:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



create PROCEDURE [dbo].[HorsesPaging2]
	-- Add the parameters for the stored procedure here
	-- exec [dbo].[HorsesPaging] 1000, 20
	@StartRow bigint=1,
	@PageSize int=15
	
AS
BEGIN


SELECT * FROM vwHorses WHERE HorseID IN 
    (
    SELECT TOP( @PageSize) HorseID FROM Horses WHERE HorseID 
		NOT IN  (SELECT TOP (@StartRow) HorseID FROM Horses)
        
        )
        
         /*ORDER BY SortColumn*/
    /*ORDER BY SortColumn */
    
--ORDER BY SortColumn

end
GO