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...

You can't do things like "WHERE txtField LIKE '%Smith%'" with a text column, for instance.

That's not true, you can use LIKE and IS NULL on a text column, you can't use any...

It's the winter solstice and shortest day down here. Sunrise was about half past 6 this morning and sunset will be around quarter to six this evening. (about, I'm not...

You don't need the brackets around the select. Also the Order By is not necessary in an insert. The concept of order of rows in a table is meaningless. Order the...

Isaac Asimov's robot stories, especially The Positronic Man (with Robert Silverberg). The book I, Robot is a collection of short stories

Also Arthur C Clark's Rama series and Songs...