You could 'build' the hierarchy dynamically in your order by :

SELECT TOP 1 answer FROM lookup

WHERE (id1='100' or id1='other')

  AND (id2='100' or id2='other')

  AND...

OK. Don't know if this is an answer to my post or not? Did you try that and did it return the right data? If not, try posting some (relevant)...

Yep, your right, stupid me ...

You should of course add a 'join' on the UPC_EAN code to the WHERE of the EXISTS.

... AND...

Strange...

Maybe same problem with the WHERE clause:

Add the IM2.Vendor to the subquery in your EXISTS clause.

Long, long time ago, someone posted comparable problems in a thread about using IN vs EXISTS.

If I recall correctly, you should fully qualify the UPC_EAN in the EXISTS clause. Otherwise...

Are you using SQL or Windows Authentication?

The difference originates from the use of the GROUP BY clause.

In your first query, SQL Server will build the complete result set, gathering all data for each and every f.fund...

I would try using a DTS task for this. The ASP page can then trigger the DTS task, for which you don't have to wait until completion.

Another way is to...

Are you sure it's not a problem with the Update statement. If you look up the topic 'INSTEAD OF UPDATE trigger' in BOL, you can read that

June 26, 2003 at 4:24 am

#463199