Philip, thank you very very much for the reply and the explanation.

-matt

Thanks for all replies.  We did find the problem.  Two unique indexes against the same column instead of against two separate columns.

However, as long as I have everyone's attention in...

Thank you very much to all whom replied.  I appreciate it a lot.

In this case since each view was called in many places (in the order 300 total) we felt...

Jeff,

I agree, VIEWS are not the place to put ORDER BYs (in general).  The situation is the client is migrating from Access and they are using an Access ADP against...

Hi Shashi,

In your example titleid may be the primary key.  Please try on a different column and does it still work?  This would be helpful to know.  Because then we...