Can you solve this sort problem?

Question

Can you solve this sort problem?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 1

RBarryYoung (1/1/2009)
Heh. Gail is much faster than me... 🙂

Heh... while that may be true, your patience and depth of explanation are noteworthy. I'd have killed and eaten by now... 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

Jeff Moden (1/2/2009)
RBarryYoung (1/1/2009)
Heh. Gail is much faster than me... 🙂
Heh... while that may be true, your patience and depth of explanation are noteworthy. I'd have killed and eaten by now... 😛

Aw, shucks. :blush:

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Roy Rogers SSCertifiable Points: 7712 More actions · Answer 3

Mark why is it the sub-set within that page you want to sort?

Try any websites (ex. Shopping) when you sort it will sort the entire record and then page the records.

If you have your reasons to use the sorting within a page. Try to put the data of the page (Between rowids) into a temp table and then sort the data intemptable for the result sets.

Regards,
gova