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

May be a small aperetif?

If you look at a postscript file you can almost tell what is going to print. Within certain limits you can say the same about...

Try this in the Northwind database to select the every 5th record from products

DECLARE @tbl TABLE (RowNum INT IDENTITY(1,1), ProductName VARCHAR(40))

INSERT @tbl (ProductName)

SELECT ProductName FROM dbo.Products

SELECT * from @tbl

WHERE RowNum...

Darwin Information Typing Architecture.

It uses XML for content mark-up. The organisation of the content is disciplined and the system is designed to merge topics of information together into a...

This does the trick with CAST

IF @ColumnName IS NOT NULL

BEGIN

INSERT INTO #Results

EXEC

(

'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(CAST(' + @ColumnName + 'AS VARCHAR(3630)), 3630)

FROM '...