>Jim,
>
>You may have index corruption. Try to reindex all tables involved.
>
>>Good suggestion but so far I haven't been able to identify anything that would cause this. But I have discovered that some of the prices in the view are totally unrelated to the data in the table. And some of the data in the tables is duplicated, which shouldn't be happening.

Sergey,

I thought of that but wouldn't that affect both the view and SQLEXEC()? They're both running the same sql query code.