More on Returning a Subset of a Recordset

• jwiner

  SSCrazy

  Points: 2241

  More actions

  September 26, 2001 at 12:00 am

  #104554

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset.asp

• MagneticNoodle

  Grasshopper

  Points: 13

  More actions

  December 19, 2001 at 5:16 am

  #421278

  lol - ok, nicely done. Somewhat more efficient than cursors 🙂

  Why don't you just build a table and then use a between? The following example is in T-SQL as it allows the handy table var (automatically cleared after sp exec)

  CREATE PROCEDURE getSubset (@start int, @end int) AS

  DECLARE @tblTemp TABLE (pID int,

  intData int,

  strData nvarchar(50))

  INSERT INTO @tblTemp

  SELECT /*insert main functionality of sp here*/

  SELECT *

  FROM @tblTemp

  WHERE pID between

  @start and

  @end

  ORDER BY intData

  Life's not difficult...enjoy it.

  Nood!e

• jwiner

  SSCrazy

  Points: 2241

  More actions

  December 19, 2001 at 5:36 pm

  #421320

  Thanks for your feedback. Your approach is definitely a solid option. Many ways to skin a cat.

• ilan rosen

  Grasshopper

  Points: 17

  More actions

  July 19, 2005 at 8:03 am

  #575493

  what happens when the field you order by on

  is null

  for many records

  for example :

  select top 10 custnum,custname from customers where custname >

  (select max(custname)  from customers ) A order by custname

   

  when you got many records where custname = null

  then the result is null

  resolve that please