SQL Server 2000 query error
You need to qualify SucNo DESC in the ORDER BY i.e. p.SucNo DESC.

Presumably the SQL2000 query processor can't deduce that f.SucNo and p.SucNo resolves to the same sort, whereas SQL2008 can.