[SQL] Rule for multiple entries

2006-12-13 Thread William Scott Jordan
Hi all! I have a rule in place that is supposed to adjust a value in one table based on how many rows are added or deleted to another table, but I'm not getting the results that I hoped for. If a single sql statement adds or deletes multiple entries, the rule still only adjusts the value by

[SQL] Referencing tables are grinding UPDATE to a halt

2007-01-15 Thread William Scott Jordan
Hey all! I'm having some trouble with a simple update on a table that only has about 250,000 rows in it. The table itself looks something like: CREATE TABLE price_details ( price_detail_id int PRIMARY KEY, private bool ) ; There is one table that references price_details, but isn't affected

Re: [SQL] Resolved - Referencing tables are grinding UPDATE to

2007-01-15 Thread William Scott Jordan
Yeah, I forgot about the RULE on that table. Ignore my previous email. -Scott At 01:26 PM 1/15/2007, you wrote: Hey all! I'm having some trouble with a simple update on a table that only has about 250,000 rows in it. The table itself looks something like: CREATE TABLE price_details ( pric