Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread SQL
Sat, Nov 3 2007 5:54 PMPermanent Link

"Andrej Bivic"
How can I limit the number of records, query is targeting? Let say, I want
just first 50 results in a query.
Please, advise

Andrej

Sat, Nov 3 2007 6:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Andrej,

<< How can I limit the number of records, query is targeting? Let say, I
want just first 50 results in a query. >>

You can use the TOP clause to do so.

BTW, please do not tag on new posts to very old threads.  It makes it very
difficult to follow the flow of the posts.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Nov 4 2007 5:56 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>BTW, please do not tag on new posts to very old threads. It makes it very
>difficult to follow the flow of the posts.

Unless you adjusted his header before I downloaded this morning he didn't. Its just M$'s wonderful technique of threading on the title not the references. On the other hand if you did adjust the header my apologies for this post.

Roy Lambert
Sun, Nov 4 2007 1:18 PMPermanent Link

Dave Harrison
Roy Lambert wrote:
> Tim
>
>
>>BTW, please do not tag on new posts to very old threads. It makes it very
>>difficult to follow the flow of the posts.
>
>
> Unless you adjusted his header before I downloaded this morning he didn't. Its just M$'s wonderful technique of threading on the title not the references. On the other hand if you did adjust the header my apologies for this post.
>
> Roy Lambert
>

Roy,
    Yeah, it showed up as a new thread this morning with Mozilla. Tim's
gotta stop using antiquated technology (anything with MS in the name). Smile

Dave
Mon, Nov 5 2007 1:09 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Unless you adjusted his header before I downloaded this morning he
didn't. Its just M$'s wonderful technique of threading on the title not the
references. On the other hand if you did adjust the header my apologies for
this post. >>

No, I didn't.  Apparently you are correct - it is OE working its magic.

My apologies to Andrej.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Nov 5 2007 2:22 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


It was ONE of the motivators behind writing TMaN - I got fed up of threads going out of whack.

Roy Lambert
Tue, Nov 6 2007 1:13 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< It was ONE of the motivators behind writing TMaN - I got fed up of
threads going out of whack. >>

I swear that one of these days I'm going to get that up and running here.
However, it's behind getting our manuals up on the web site as dynamic page
serves with searchable content. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Image