Viewing 6 posts - 1 through 6 (of 6 total)
No Tim , I never did find a solution to the problem and even posting questions on the MS newsgroups didn't yield any explanations as to why accessing the Inserted...
April 13, 2005 at 3:17 am
The database I was doing all the testing/analysis on was a copy of a live database on one of our development servers. I was the sole user of the database so all the performance...
January 22, 2005 at 5:45 am
As far as cutting down the number of rows processed, that is effectively what I am doing with...
WHERE PoliID IN (SELECT PoliID FROM Inserted)
...(PoliID is the...
January 19, 2005 at 7:58 am
Thanks for trying to help guys. I am still battling away and trying to avoid going back to putting the trigger code in SP’s but I have to improve...
January 18, 2005 at 1:35 pm
The table has approx 60,000 rows so not a vast amount. As for the use of the IN, I also do not like using it unless I have to but...
January 17, 2005 at 6:09 pm
SQL2000 + Service Pack 3a
Recursive Triggers are switched OFF
January 17, 2005 at 4:47 pm
Viewing 6 posts - 1 through 6 (of 6 total)