thanx remi. it works fine

the 3rd maximum value must be 1000 not 2000

your sql returns as follows

deptno               sal_3rd             

-------------------- --------------------

1                    2000

2                    1000

3                    2000

what i need is

deptno               sal_3rd             

-------------------- --------------------

1                    1000

2                   ...

declare @StartDate varchar(10), @EndDate varchar(10)

set @StartDate = '01/02/2005'

set @EndDate = '01/31/2005'

Select * From temperatures

Where TempTime between @StartDate and @EndDate

select * from temperatures

Where temptime >= convert(smalldatetime,@StartDate,101) and TempTime <= convert(smalldatetime,@enddate,101)

in the create a new DSN dialogue box

at the server combo box type the IP address of the server instead of the server name.

again if it won't works

go to start...