SQLServerCentral / Discuss Content Posted by Jon Winer / Article Discussions / Article Discussions by Author / More on Returning a Subset of a Recordset / Latest Posts

RE: More on Returning a Subset of a Recordset

ilan rosen — Tue, 19 Jul 2005 08:03:00 GMT

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

RE: More on Returning a Subset of a Recordset

jwiner — Wed, 19 Dec 2001 17:36:00 GMT

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

RE: More on Returning a Subset of a Recordset

MagneticNoodle — Wed, 19 Dec 2001 05:16:00 GMT

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) ASDECLARE @tblTemp TABLE (pID int, intData int, strData nvarchar(50))INSERT INTO @tblTempSELECT /*insert main functionality of sp here*/SELECT *FROM @tblTempWHERE pID between @start and @endORDER BY intDataLife's not difficult...enjoy it.Nood!e

More on Returning a Subset of a Recordset

jwiner — Wed, 26 Sep 2001 00:00:00 GMT

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