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

The stored procedure is designed to search for columns and records where a supplied string is contained within the column.

Numeric datatypes won't work in this way. What exactly is...

The difference is that an entire system would stop functioning correctly if it couldn't cope with the rollover to a new century, where as if you don't use XML....so what?

As far as I am concerned XML was supposed to be something that separated out content from presentation for the web. It was a development of SGML.

I agree with...

What happens if you create and explicit temporary table of the require structure and do several insert selects instead of the union query?

There are 2 parts to this.

DATEPART returns an integer and therefore you must CAST or CONVERT the returned value if you want to concatenate the string.

SELECT DATENAME(MONTH, DATE)+', '+ CAST(DATEPART(YY,DATE)...

EXEC sp_attach_db @dbname = N'<>',

@filename1 = '<>',

@filename2 = '<>'