Solved the puzzle, but haven't got a solution yet.

On 28th of January, a post appears on the microsoft.public.sqlserver.dts forum (Subject : "SQL2000 sp3 et al.") featuring some e-mail communication between...

Been there, done that

Reapplied SP3 for Win2K and SP3 for SQL2K (in that order), but the problem still is not solved.

BTW, the problem persists on the...

No, some odd 100 fields. It's an export of a table to a delimited text file. The package is created using the wizard. No special stuff, just clicking 'Next...' all...

If this is a specific problem, only relating to the class id-1 and class id-2, the following query will do the trick.

SELECT cs1.student_id

FROM (SELECT student_id 

...

This should do the trick.

SELECT s.SalesMan, s.Date, l.Limits - s.Total

FROM

   (SELECT s1.SalesMan, s1.Date, 

        (SELECT sum(Amount) FROM...

I believe it says that your windows 2000 is on SP2. SQL Server does not display it's real SP version.

If you get the 'Microsoft SQL Server 2000 - 8.00.760 (Intel...

I think the following query solves your problem :

SELECT e.EmpNum, e.EmpName, s.NrSupervise

FROM Employees e

     LEFT OUTER JOIN 

    ...

I've been banging my head against the wall all weekend, but to no avail.

Don't seem to get this one nailed down without using cursors... and even with cursors, it's not...

See your point. Next time, I'll try to investigate a bit further.

Still on it, but I don't think my employer will like me spending his time on this right now....

Here's a more complete solution...

--Create a temp table, with an identity

SELECT IDENTITY(int,1,1) as combo_temp,

       o1.ordkey,

     ...

Oh boy oh boy. This one's a challenge

The following query returns a recordset with the correct records in it.

select o3.ordkey, count(distinct(o3.ordprod)) as...

Again, have to agree with David. 'Used By' comments are usefull, but it's a pain to keep them up to date. And if you can't trust them, what's their use.

In...

Also like the comment header. Agree with David.Poole on this. And we agreed to cut out all changes in between major versions / releases.

This keeps the changelog nice and short.

First of all, I believe this is a client issue (representation of data) and not a database issue. I don't think it is possible to limit the size of a...

I think the following code should do the trick.

In the second part of the join statement, make sure you select and join by all ID fields.

Then, you join this to...