Use TOP with ORDER BY ....

SELECT TOP 2

START_DT, END_DT

FROM

dbo.yourTable

WHERE

END_DT <= GETDATE()

ORDER BY

END_DT DESC

What have you tried?

More info here .. http://msdn2.microsoft.com/en-us/library/aa275767(SQL.80).aspx

My humble recomendation is ...

C: OS + SQL Binaries

D: Data Files - RAID 1 or 10 (like Steve Suggested)

E: Temp DB & Log Files - RAID 0

F: Index Files -...

I say just do a full backup after every UPDATE or DELETE. :w00t:

Only to show that there is more than one way to get something done.....

-- First create some test data

DECLARE @testUserLoginDuration TABLE (starttime DATETIME, userid INT)

INSERT @testUserLoginDuration

SELECT...

SQL ORACLE (3/18/2008)

---

If my understanding is correct, you would like to compare which is better, an ad hoc query or a stored procedure.

If so, adding your query in your stored...

First, the answer to the question: NOPE

Second, a possible solution: Get Red Gates' SQL Compare and SQL Data Compare. Create an empty SQL 2000 database and use SQL Compare to...

There is always more than one way to skin a cat, and the same applies to TSQL.

One way...

SELECT unitid

FROM demotbl AS d

LEFT JOIN nesunit AS...

http://www.sqlreportingservices.net/BookSrs2000/default.aspx

Yes, it works with 2000 and I believe it's on the SQL Server media. Oh, it's FREE and not too dificult to set up. Search these forums, or the web...

Sounds like a perfect situation for a Reporting Services Fileshare Susbscription. 😀

Check this out...

http://www.amazon.com/Hitchhikers-Reporting-Services-Microsoft-Windows/dp/0321268288

I believe it is a semi colon ;

LOL, that's now on my wall!