Technical Article

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 "", […]

You rated this post out of 5. Change rating

2005-09-08 (first published: )

239 reads

Blogs

Executing One Line in VSCode–#SQLNewBlogger

By

I wrote about arrays in PowerShell last week, but I realized one of the...

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Read the latest Blogs

Forums

Selecting from a view, base table has a DENY on a column

By pveilleux

This is something I've never seen before and I can't think of the right...

JSON data with Pivoted

By Tava

Hi All, I need some assistance and not sure how to achieve the expected...

SQL Window Functions Series: LAG() and LEAD()

By Nikhil Bangad

Comments posted to this topic are about the item SQL Window Functions Series: LAG()...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers