from the example, if I'm not mistaken, the statements that are being rolled back are direct inserts to the table, but the index on the view is what is stopping...

Is the "WITH SCHEMABINDING" hint necessary to enforce the view index on the table inserts?

Okay, here it is. I changed John's query to have the cust_id's equal each other, like so:

SELECT a.return_indic,

COALESCE (r.rate_quote_id, '0') AS...

Thanks for your attention on this. It's driving me a little batty.

I believe it's not working because of the following:

in the account table, there is a row with...

Okay, I agree that in theory this should work. Could there be some server setting that is making it not work, like an ANSI Nulls setting?

John -

Thanks for the reply.

My original post criteria is all rows from account where cust id = 1117, and any rows from return where (the cust_id = 1117 AND...

No luck. I tried the following query:

SELECT Customer_rate_quote_account.return_indic,

COALESCE (Customer_rate_quote_return.rate_quote_id, '0') AS rate_quote_id

FROM Customer_rate_quote_account LEFT OUTER JOIN Customer_rate_quote_return

ON (Customer_rate_quote_account.cust_id = Customer_rate_quote_return.cust_id)

WHERE (Customer_rate_quote_account.cust_id = 1117)

AND ((Customer_rate_quote_return.rate_quote_id = 1800450)

...

thank you for that reply. It is something solid to go on!

quote:

---

With fixed length types like char, int, and so on...

Sorry Frank, I know the cross post is a no-no. Maybe you can help... I couldn't figure out how to delete the post in the DTS area, and...

Thanks for the reply Frank. I've been searching high and low for an answer to this, but haven't been able to find anything. I know that there is...