I'm reading Sybex book, Mastering SQL 2000, and I'm having problems with two
queryes.
1-------------------------------------------------------------
USE pubs

I have the following query:
SELECT     TOP 100 PERCENT Company_Code, Well_Code, Effective_Date,
Interest
FROM         dbo.HUD_Expense_Interest_Group1

Application is a Work Tracking/Timesheet database.
The increments of work are stored in the TimesheetItem table.  This
contains, inter alia, the Work Code, the Start and the Duration that
the employee spent that day on a particular project.

I posted this to the ms sql clustering news group, but I thought I'd
post it here just in case someone here knew the answser.  This problem
has had me baffled for 5 months, and I'm not seeing any support
articles from Microsoft on it, yet.  Anyone here got a clue?

We have a legacy client-server client application (developed with Centura
SQL Windows/32) that connects to a SQL Server 2000 database. In our LAN it
works without mayor flaws. Recently we added support to some remote offices
by using W2K terminal server. The decision was not to ...

I want to know the password of one user... how can I know... I have a admin
rights... I don't wanna change the password ... I only wanna know.....
Thanks in advance..

Can any one tell me about the comparision of SQL Server 2000 & SQL Server
2005. Like any website where I can find the enhacement like
1)
SQL Server 2005 :

I have a table (tblA) that records the RecordID, UserID and
LastViewedDate (DateTime) of each record opened in tblB where RecordID
is the PK in tblB. I want to construct a query that groups all records
in tblA by RecordID, filters by UserID and keeps only the most recent

I have a customer who has a SQL Server 2000 DB and we are needing to
get to this DB through ODBC.  I had setup a DSN last week that
connected fine to this DB, and was preparing to build a script to
manage transfers of data to and from one table to another.

VB.NET 2003 / SQLS2K
The Stored Procedure returns records within Query Analyzer.
But when the Stored Procedure is called by ADO.NET ~ it produced the
following error message.

I'm running a SQL 7 db on a LAN in city A with other users accessing it from
another city (city B) over a WAN. Obviously the WAN users are getting much
slower access to the data. One thing I was wondering was if it was possible
to have two versions of the database, one on each ...

SQL 2000;
I have a table that has info from 2001 thru 2005,  I want to create new
tables and remove records from the original table to the new tables, based on
year.

I am having some difficulties making a sql-statement.
I took the Northwind database as an example.
I want to return the customernumbers from the orders-table, where the
orderdate is 1996/8/23 or 1996/8/27 or the whole month of september.

I'm hoping someone can tell me how to construct a stored procedure that
deletes all records in tblA not matching the PK in tblB
This gives me the recordset of all records in tblA with no matching
records in tblB (ID is the PK in tblB)

I am practicing SQL and just using the MSDE (free version of SQL). Is there
a way that I may access the database thru a free query analyzer just like in
MS SQL?
regards,