Why not create your stored procedure to do your aggregation into a summary table then use MS Excel to do your Crosstabs?

I wish Microsoft would document all these undocumented features.

If they want to put a disclaimer saying "we don't recommend you use this" or "this feature isn't guaranteed to be in...

The link below lists a few to do with disabling hints.

http://www.sql-server-performance.com/hints.asp

I've had the "too much data" things as well.

Because the sales activity was regarded as so important we developed special scripts that produced a specific sales version of the database.

A...

I've read "Stupid White Men" and seen "Bowling for Columbine",  which for some reason is billed as a "comedy" rather than tragedy.

As I get older and ever more cynical I am increasingly...

Poor sod would blend in, but his dialysis machine might stand out a bit.

Personally, I believe that 90% of Al Queada are living in the London area, probably in flats...

I think Antares answer could do with being inserted in the FAQ section.

Unless you have a very good reason for this I would always insert the field at the end of row.

After you have done it, remember to do an sp_recompile on...

OK, I know that the question is hypothetical but who combines a major application upgrade with a major code change?

I'd play safe and plan...

The most important part of ANY system is the data, and to a customer the most important data is THEIR data.

When I was showing geodemographic marketing systems we would deliberately...

On this site's main menu, it is on the resources submenu.

Interesting stuff!

The State field is the next field following the 4 fields that comprise the clustered primary key if that is what you mean by being on the trailing edge.

I...

http://news.bbc.co.uk/1/hi/england/suffolk/3389957.stm

They probably did

Glad you liked it Chris,

The more I look at stats the more sceptical I am about government statistics.  Lies, damn lies and statistics and all that.

My favourite quote was that...