Here is another possibility using a subselect.

Uses sample tables from Jeffs response above.

 SELECT yt.*

   FROM #yourtable yt

  WHERE

 yt.rec_id = (select Max(rec_id) from #yourtable where yt.employee = employee)

Robert.

The only source I could find for RS2000 was the actual CD Media available for shipping costs.

http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx

The only way I found to get sql 2000 rs was to order the media.  The cost was s&h only.

http://www.microsoft.com/uk/windowsserversystem/reporting/howtobuy/default.aspx

Check the Sql Agent jobs on the dest server.  You should delete the jobs created by the maint plan.

Bob.

It appears the when using the 'Report' object, it must passed to a class and not used in the local code.

The following code works:

Dim objRwh as RsProtoTypeNameSpace.RSProtoTypeMethods

Protected Overrides Sub OnInit()

objRwh...

I had a similar problem when setting up log shipping.  The root cause was Enterprise manager had my primary server registered as (Local) instead of the actual server name.  Then the...

SQL Server 7.0 will NOT run on Windows Server 2003.  It will run 2000 and NT.

I set my 8gb Win2003 server to 8192 max setting.

Using task manager, it keeps about 200-300mb available.

Sql server EXE uses about 98mb instead of the 1.6gb.

The extra memory is allocated to the...