Paging - Returning a Subset of a Recordset

Use this script to navigate your recordset a page at a time containing a specific number of records and in a specified order.I use the supplier table of the northwind Database to demonstrate thisReturn List of suppliers, ordered by supplier desc, 10 records at a timeexecute prc_lov_SUPPLIERS "", "Suppliers", 1, 1 ''Page oneexecute prc_lov_SUPPLIERS "", […]

2005-09-08 (first published: )

236 reads

Blogs

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Read the latest Blogs

Forums

Converting minutes to hh:mm:ss

By DaveBriCam

I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...

Interpreting Index Usage Stats on an Availability Group

By data.jedi.ken

I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...

SQL Server Performance Counters

By alex.sqldba

Here's a question that feels like I'm asking if a tree falls in the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers