Books online doesn't say either way, from what I could see.

Try running this. The trigger gets executed once. All rows inserted are in the inserted table.

CREATE

Why do you want to make them db_owner? Users should never be part of the do_owner role.

Create your own role, add all users to that role and grant the role...

Not cursors, please. Cursors in triggers kill performance. By the looks of the trigger you should be able to change the updates to set-based.

Here's a section of your trigger...

No, they run once per statement, whether it be insert, update or delete. Actions are slower because of the additional code and stuff in the trigger. A well-written trigger shouldn't...

Insert triggers, like any other trigger, fire once per operation. If an insert inserts 10 records into a table in a single operation, the trigger will fire once and the...

What do you mean by 'didn't work'? Threw an error? Gave unexpected results?

One thing I noticed in the 'section 1' was the line SET ROWCOUNT 1 which, from what I...

Order of operations within a trigger is the same as within any other sql code, from top to bottom according to normal control flow commands (while, if)

I think you left out the group by

SELECT c.vcPostcode, COUNT(r.SFID), COUNT(t.iCALL_RESULT_ID)

FROM Customer c LEFT JOIN Contact_Result r

  ON c.SFID = r.SFID

LEFT JOIN Contact_type t

  ON r.iCALL_RESULT_ID = t.iCALL_RESULT_ID

  AND...

You can set which trigger is the first to fire and which is the last. If that isn't done, then the triggers will fire in no defined order.

Looking at...

Can you post your table structure, some sample data and expected results please? That would make it much easier for us to help you.

Thanks, those functions will be very useful. I know IsNumeric was shaky, I didn't realise it was this shaky.

Another interesting discovery from this - CAST('8,92' as FLOAT) throws an error,...

The code posted is the query I found. I've tried converting to numeric, same result.

Thanks Sergiy, but that was the first thing I tried, along with case, and no joy.

Thanks...

Getting it too. Personally I find it quite annoying as the popups aren't always that relevant and they popup 'by accident' interupting my reading.

Some new advertising perhaps?

We had a very similar problem a while back, and after intensive debugging and assistance from MS support, tracked it down to occational IO problems with the SAN and a...

The indexes will speed up the update because they greatly increase the speed of finding the records to update. The time taken to update the indexes is minimal.

How many...