Sybase??

You could use ROW_NUMBER or you could use APPLY, like this:

SELECT od

-- I'd use a function for this, to mask the complexityfrom your queries:

Thanks Bhavesh.
If I were given this query to tune, including access to a test database, then I'd break it down into manageable chunks and tune each chunk separately. Here's...

Essentally the same subquery appears twice in the part of the query which is attached to the plan. Rather than read...

CREATE INDEX ix_Stuff