Re: top clause in sql Server

Author: Stephen Russell

Posted: 2011-02-24 at 11:40:18

On Thu, Feb 24, 2011 at 9:18 AM, Richard Kaye <RKaye@artfact.com> wrote:

> Change your filter to between 13 and 22 instead of less than 23?

----------

When you know your data you can code it to be between 13 and 22. How

do you let the data grow and know what values to pass in?

The code to multiply the volume of the sub query x the page # you are

on is nice when the index is char() and they fill it with int. This

will bite developers when they mix up the values in the char() on you.

Just saying.

--

Stephen Russell

Sr. Production Systems Programmer

CIMSgts

901.246-0159 cell

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/AANLkTinY0wugWLhepjEjaZqhbN99dFxDEB4D+6jHjDGX@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2011 Stephen Russell