Yes, I read the sp_lock page before I posted my question. In my sp_lock output, I also saw the resource for PAG is a combination of the file id and...

Thanks

Do you know the bug #? and where I can obtain the patch

-- Peter Lo

The following query works in MS SQL Server and produces the same result. You may want to run showplan to determine whether additional indexes are needed.

SELECT m2.Awb,

       m2.Flight_no,

       m2.Flight_date,

       m2.Origin,

      ...

You can create a view which has the same column list as your source table and a WHERE clause:

create view v_xxx

..

as

select

..

from <source table>

where <column> >= dateadd(day, -180, getdate())

go

Then, you can...