Looks OK to me, but I am not an expert on OPENQUERY.

My bad, I got it backwards. Try:

SET QUOTED_IDENTIFIER OFF

instead.

You should use two separate BULK INSERT commands, to the same table.

I have to confess, I've never even heard of an MBD file. Did you mean an Access .MDB file?

Glad I could help.

CREATE [UNIQUE] INDEX idxTablenameKeyDT

ON TableName ( Key, DT )

Well, it does not appear that the "DT" column is in the index, and since it has to get both it and the join Key values, it's probably faster to...

Heh. Well, unless they're displaying with SSMS, there's *something* doing the presentation, otherwise, why try to format it?

My Pet Peeve:

Posters who say "...this returns an error." or "...this doesn't work."

People; PLEASE do not leave it at this, give us ALL of the relevant information! If it...

Can it be done? Yes.

Should it be done? No.

This is a presentation problem and it should be handled by the presentation layer, NOT the data manipulation layer.

This should do it:

Create Trigger trgJuggleDates

On tablename

After Update

AS

IF Update(Date1) OR Update(Date2) or Update(Date3)

BEGIN

Update T

Set Date4 =

CASE When (Date1+Date2+Date3) is Null Then Null

ELSE ( Case...

Although I do not know your specific situation, it is usually true that you should not be taking copies of the Employees database out of your office and putting them...

Though looking at it I think that you will need more apostrophes...

Try this:

', DateUpdated = '+ CAST(GetDate() as varchar(24))+ CHAR(13)+

yes