<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>Comments on snippet: 'SQLServer 2000 T-SQL Stored Procedure for providing paginated results'</title>
<link>http://snipplr.com</link>
<description>Snipplr comments feed'</description>
<language>en-us</language>
<pubDate>Fri, 24 May 2013 22:56:24 GMT</pubDate>
<item>
<title>aspcorpo said on 6/25/10</title>
<link>http://snipplr.com/view/112/sqlserver-2000-tsql-stored-procedure-for-providing-paginated-results/</link>
<description><![CDATA[ could you please tell me whats eg: of use?

USE [Database]
GO

DECLARE	@return_value int,
		@TotalRec int

SELECT	@TotalRec = *

EXEC	@return_value = [dbo].[sp_Easypaging]
		@TABLES = N'*',
		@PK = N'*',
		@JoinStatements = N'*',
		@FIELDS = N'*',
		@Filter = N'*',
		@Sort = N'*',
		@PageNumber = *,
		@PageSize = *,
		@TotalRec = @TotalRec OUTPUT,
		@GROUP = N'*'

SELECT	@TotalRec as N'@TotalRec'

SELECT	'Return Value' = @return_value

GO ]]></description>
<pubDate>Fri, 25 Jun 2010 02:44:37 GMT</pubDate>
<guid>http://snipplr.com/view/112/sqlserver-2000-tsql-stored-procedure-for-providing-paginated-results/</guid>
</item>
</channel>
</rss>