Ha! Actually I'm just outside Wellington (the capital). There is some friendly rivalry...

Well that's...

This bit concerns me slightly. Setting TRUSTWORTHY on is not the recommended practice - you should sign the assembly, generate an asymmetric key for...

I should point out that it is rather specifically optimized for the test data presented...

I knew I should have posted a CLR solution - I am becoming type-cast! 😉

I also learned that you can combine multiple...

Exactly my sentiments...well almost exactly. I deliberately didn't read the editorial when it came...

I see what you mean (though Auckland seems to have moved a little since the last time I was there ;-)).

That's raised your carbon footprint for the year a bit.

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

A very similar example (and some useful others) can be found in Books Online:

WITH common_table_expression (Transact-SQL)

You have the right basic idea, but look at sys.triggers too.

USE tempdb;

GO

CREATE TABLE dbo.Test (A INTEGER NULL);

GO

CREATE TRIGGER [trg dbo.Test IUD]

ON dbo.Test

AFTER ...

famille.espie (3/26/2010)

---

Are you a professionnal ?

You never should be partitionning a disk ! Never ! Thid was not made by microsoft for this use. This was made to bypass the...

Hey! Don't go blaming Auckland! :crazy::angry:

(joke)

A laudable goal, but limited in its application since you cannot get details of the object that caused the trigger to fire, as I think you are in the process...

Kingston Dhasian (3/26/2010)

---

I had actually googled some information about the error but i was of the impression that the number -0.6401 was of type DECIMAL(5,4). I didn't know SQL Server...

Ah, yes of course. It's been a couple of days and I had forgotten the context! Maybe in some future released ALTER INDEX will be expanded (again) to...