Here is the first code I write in my blog. I wrote this during my lunch time to demonstrate how to sort the records according to the latest value entered. it is a scripts actually. :-). What the different between code and scripts? :-?
-- demonstrate page records in SP
CREATE PROCEDURE dbo.GetCustomer
(
@PageSize INT,
@PageNum INT,
@TotalCount INT OUTPUT
)
AS
BEGIN
SET @PageSize = 20
SET @PageNum = 1
DECLARE @FirstRecord INT
DECLARE @LastRecord INT
SET @TotalCount = (SELECT COUNT(*) FROM dbo.Customers)
SET @FirstRecord = (@TotalCount - (@PageSize * @PageNum))
SET @LastRecord = @TotalCount - ((@PageNum - 1) * @PageSize) - 1
IF OBJECT_ID('tempdb..#Temp') IS NOT NULL
BEGIN
SELECT TempId, CustomerID
, CompanyName
FROM #Temp
WHERE TempId BETWEEN @FirstRecord AND @LastRecord
ORDER BY TempId DESC
RETURN
END
CREATE TABLE #Temp
(
TempId INT IDENTITY PRIMARY KEY
, CustomerId VARCHAR(20)
, CompanyName VARCHAR(300)
)
INSERT INTO #Temp
SELECT CustomerId
, CompanyName
FROM dbo.Customers
SELECT CustomerID
, CompanyName
FROM #Temp
WHERE TempId BETWEEN @FirstRecord AND @LastRecord
ORDER BY TempId DESC
RETURN @TotalCount
END