Yup,

that was it. My table has way more that 8 fields. I followed the BOL which is evidently wrong.

Thanks for info, Jay. I thought that I was going crazy.

Again, thanks...

Nope,

That did not work either.

This is plain vanilla SQL installation. It should work just fine, what is wrong with it?

Jakub

I see,

Thanks for your help.

Jakub

I found out hot to enable nested triggers in BOL.

DUH

Should I have them enabled? I thought that triggers fire once per row, regardless how many rows are updated.

Jakub

Probably not.

how can I tell if I have them enabled?

Thanks,

Jakub

I got it now, slower wire here

Thanks.

It only works for the five day interval, if I wanted to build a generic function I would have to account for all...

I am probably little dense, but 5,6,7,8 days?

I am not sure what do you mean.

What if the start day is friday and I need to add 2 days

i.e. DateAdd(day, 2,...

Figured it out!

The note field in the trigger was null. SP did not like that.

It is firing now.

Thank you all for help

The identity value is already available in the trigger. I send myself an email from the trigger (code below) and it has the right value. So no need for scope_identity()

I...

I tried that but it dosent work. The LogID is an identity column. Is it available as part of insert values or do I have to get it with 'SELECT...

Duh??? It runs fine today. I have no idea why. I run the Maint. Plan on the server over the Weekend, that's the only change.

Thanks for all your help

...

I fixed if. Just a conversion:

SELECT @Note_10 = @Note_10 + CAST(WONo AS varchar(15)) + ', ' FROM PELDMS.dbo.ImportLog1 WHERE Profile = @Profile_3

BUT still no update

Debugger stops on the UPDATE...

Antares686,

I tried your slick code but it fails on the SELECT statement with:

Server: Msg 245, Level 16, State 1, Procedure sProfLogActiveSDGs, Line 13

[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the...

quote:

---

This will give you the exact same output

-----------------------------------------------------

SET @Note_10 = @Note_10 + '----'

SELECT @Note_10 = @Note_10 + WONo + ', '...

quote:

---

Why you are using 'EXEC (@SQLs)', why can't you update directly with your Update statement?

Are you sure that your LogID is...