Top 10 downloads January 2003

Top 10 downloads January 2003

Post by Peter Wage » Mon, 03 Feb 2003 04:58:14



The most popular downloads from the Software Repository  For January 2003
are

Utils2_ak  Art Kagel  92
Utils_ak Art Kagel 88
Alarm  Clay Irving 63
Utils4_ak  Art Kagel 63
Lockwt Eric Herber  61
Defrag_table   John Clutterbuck 55
Dbamon   Jack Parker 54
Upd_stats  Doug Wilson  53
Movetab   Eric Herber  48
Utils_jl Jonathan Leffler 47

                          With regards,
                          Peter Wages
                          For The IIUG Software Repository

 
 
 

Top 10 downloads January 2003

Post by Jack Parke » Mon, 03 Feb 2003 07:35:22


DBAmon?  Good god, that thing is ancient.  I have an updated version
somewhere.

cheers
j.

----- Original Message -----


Sent: Saturday, February 01, 2003 2:58 PM
Subject: Top 10 downloads January 2003

> The most popular downloads from the Software Repository  For January 2003
> are

> Utils2_ak  Art Kagel  92
> Utils_ak Art Kagel 88
> Alarm  Clay Irving 63
> Utils4_ak  Art Kagel 63
> Lockwt Eric Herber  61
> Defrag_table   John Clutterbuck 55
> Dbamon   Jack Parker 54
> Upd_stats  Doug Wilson  53
> Movetab   Eric Herber  48
> Utils_jl Jonathan Leffler 47

>                           With regards,
>                           Peter Wages
>                           For The IIUG Software Repository


 
 
 

1. Urgent--Newbie, please Help!:-)--TOP 10 Plus Increments of the next TOP 10

Hi,

does anyone know of a Query that will return the first TOP 10 and then
the following TOP 10 in increments fof 10??

I have 2 QUERIES which will return the first TOP 10, but not the next
increments of 10. Also, does anyone know the QUERRY to return the
BOTTO 10 as well?

Here are 2 QUERIEs  I am using just to return the TOP 10:

1)

SET ROWCOUNT 10
SELECT contact_id
FROM contacts
ORDER BY contact_id asc

2)

SELECT top 10 contact6_Id
FROM contacts
ORDER BY contact_id ASC
These both work, but can't figure out how to get the next increments
of 10.

3) also tried this a suggested, but it returns bottom 10 --not what I
need.

SELECT TOP 10 contact_id
FROM contacts
WHERE contact_id in
(SELECT TOP 20 contact_id
FROM contacts
ORDER BY contact_id DESC)
ORDER BY contact_id ASC

Thanks in advance. Any help will be greatly appreciated.

James

2. Adding help *in* application

3. BDE driver development kit

4. SQL grammar

5. Getting NULL error when there are no nulls

6. Top 10 downloads - DBAmon

7. Washington Area Informix User Group Meeting - January 15, 2003