SQLTeam.com | Weblogs | Forums

Sql with html

Problem: I am building an html report and I would like to display the first 4 records of a sql select statement on the first page and the rest of the records on the second page. Potentially there will be max of 10 records.

Can I have a "counter" in the sql statement that would identify the fifth record?

You could use the ROW_NUMBER() function. See examples here

Which version of SQL Server are you using?
try order by with an offset and fetch