Oops - here is the actual error message returned.

[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=...

After much testing last night - we realized that the stored procedure called by vb works correctly under SQL 2000 Service Pack 2. The customer applied SQL 2000 Service...

That was what I tried, but in order to get the primary key clusted index, I had to drop the table and I lost all my data. I was...