select * from dbo.[db.document]

That works for me.

CREATE TABLE dbo.[db.documents]

( a int

)

GO

INSERT INTO dbo.[db.documents] (a) values (1)

SELECT a FROM dbo.[db.documents]

GO

DROP TABLE dbo.[db.documents]

GO

No, you're dead on...

I've seen names like this: l'aéropt du-Québec

That's the tablename... and I can access it with brackets, so a simple dot should not stop it!

Good point, but I'm assuming that this search is done in the inserted table (which is always scanned anyways)... but he must keep this in mind.

Are you sure you are connected to the right server / DB?

It has to work if you put the name that sysobjects gives you in brackets... that's absolutly a can't fail proposition... unless you have a corrupt installation or maybe DB...

I'd like to see the rest of the trigger, there's probablye a way to only do 1 update instead of four. Your query should look like this :

update...

Not a required feature. The fact that you need to alter the procedure suggests that you will manually (99% of the time) will change the code.

That feature has been...

Have you tried this syntax? :::

SELEC Whatever FROM dbo.[db.documents]

if that fails you can always run this to see the actual table name

Select * from sys.sysobjects where name like %documents% and...

Repeating the warning.... don't create triggers on the fly.

If you have a DBA job of creating audit triggers and want to write your own code here's how to bypass that...

That really makes...

This screams poor table design... why don't you have one row per date?

If this is the case of a report you need to run, or something of the likes, or...

Sherbrooke, Québec, Canada (90 minute south of Montréal).

It was more a contract than a job... but I'm sure I can find more of those if I need to... but I...

Sorry for my over estimations... but the last "jobs" I had, I was charging 75$ / hour, that's easily in the 6 figures. I just assume that it was...

I just found a site called payscale.com From what I can tell the average seems to be around 45-55K / year.

You might want to fill out the survey...

Montréal is in Québec, Canada.

It's one of the biggest towns in Canada.

I have no idea of the average salary there... should be at least 6 figures (my own personal guess...