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