GetClients.sql

CREATE PROCEDURE [dbo].[getClients] 
  @filterString varchar(25),
	@start int,
	@limit int
AS
BEGIN
	SET NOCOUNT ON;

	SELECT TOP (@limit)		
		clientId, 
		clientName
	FROM
		(
			SELECT ROW_NUMBER() OVER (ORDER BY clientName) as RowNum, clientId, clientName
			FROM dbo.Clients
			WHERE clientName like @filterString + '%'
		) as RowConstrainedResult		
	WHERE		
		rowNum > @start