Carl, you're wrong.

Try '2007-04-24' with DATEFORMAT dmy

If you need to count columns in a table you've got absolutely wrong idea about relational databases.

Read about SET DATEFORMAT on BOL.

Just use system function COUNT.

http://www.sqlservercentral.com/forums/messages.aspx?forumid=8

Trigger should contain single statement:

INSERT INTO dbo.IDsToUpdate (ID)

SELECT i.PK_ID

FROM inserted i

WHERE NOT EXISTS (select 1 from dbo.IDsToUpdate U

where U.ID = i.PK_ID)

Then use join to this table in you UPDATE...

> How can I use triggers avoiding that ...

Don't use cursors in triggers.

It's not the case.

I managed to get right file end in the end, but only when I eliminated dynamic SQL and # table inside of invoked procedure.

Now trying to find...

Ken's solution is preferable.

It allows to use index, if there is one.

And I would suggest to normalize you data. It eliminates so many problems...

SET NOCOUNT ON is run-time option, and it's set inside of that SP.

Yes, there # tables inside. Moreover, they are inside of dynamic SQL executed by SP at the end.

There...

It was more not for your eyes, but for OP.

You just asked right question.

Good luck with it.

Just be careful - don't mess with triggers until you sure you know what you are doing.

> Other than the possible model changes, what's your take on this Sergiy?

1. Simplicity

2. Logical integrity

3. Less processing (and processing moved to precompiled view code - more effective)

4. Automatic...

Does not look like data problem.

I selected different ranges of data for the report - same result.

But about SET options - have to give it a shot.

There is a possibility...

On one of computers I have clear MS SQL Server 2000 installation.

No Visual Studio, nothing else, just standard SQL Server development tools - EM and QA.

All dt_ procedures are there.

And...