I could be wrong here but I think the export to Excel uses the old JET libraries and that is the reason the TEXT data gets restricted to 255 characters.

If you want a global temporary table then use CREATE TABLE ## rather than CREATE TABLE #.

Be careful though. When the creating connection logs out the table will vanish...

As posted earlier immigration is a big issue in the UK right now, especially with the general election tomorrow.

We have a problem called the BNP (British National Party). Imagine...

I loved the books but hated the movie.

Gags I liked

* The gun designed by a woman!

* The bottom falling out of the airlock

* Arthur Dent's "I'm British, I know how...

Adam, I'm not sure what you are getting at.

It is possible to be valued as an individual but be irrelevant to the organisation.

Within EM right-click on your database and select properties.

Under the general tab look at the Collation name (at the bottom), the chances are it is different in one database to...

I liked the gag about a gun designed by a woman and the airlock where the bottom falls out of it, but yes, they rushed through the opening (and best)...

I thought the whole point of a cluster is that the nodes were identical and therefore if a node went down the other nodes would take over?

We originally recommended that...

If companies are in a non-competitive but symbiotic relationship it could work.

As pointed out liability for faulty code may be an issue although I suspect the sticking point would come...

Poor dumb b***ds

What about the department name column?

What do you want to happen when a salary in Company is updated?

What is the link between Company and sales_dpt?

It could be as simple as

CREATE...

I originally learnt BASIC and over the years have learnt a variety of langauges. If you are a MS shop then going for a .NET language is a no-brainer.

I...

It wasn't a slight on Canada it was a back handed compliment. My admitedly limited experience of Canada (Ontario/Quebec) and word of mouth from relatives in Vancouver, Grandfathers journal...

God I'd hate to live in Canada.

A country that defines the great outdoors, and you have to spend most of it indoors doing the impossible for the ungrateful. Bummer.

I think it is different things for different people but Kumaran certainly nails it as far as I am concerned.

"they feel that they are NOT BECOMING MORE VALUABLE by the...