Re: How to improve performance of the report's display while updating the table?

_at_Ariel
Date: 03/29/04 

Date: Mon, 29 Mar 2004 06:01:11 -0800

Thanks Uri and Wayne.

Yes, my table got join statements within.

select * from table a, table b with (nolock), table c and table d
where a.id = b.id and
          b.id = c.id and
          c.id = d.id;

// the b table I assume is the attendance table.

uri, did you mean that my result will be wrong after I use the nolock syntax?
Or you mean it will be wrong in terms of some of the data it linked will be deleted or updated?

Thanks Again