Ok, case closed - many thanks for asking. I really forgot these triggers, but they guys only support updating one record at a time, so that explains it. It's...

Thanks Jack, for the quick reply and also the good links 🙂

The idea is write a log-message that shows the old and new values of the modified fields. There is...

Thanks, Sergiy, you're a star 😉

I should have added a PRINT @sql, would have saved quite a bit of headache 😉

Many thanks

Michael

Sergiy,

the VarCode-function works fine. It is used to either return the main-code or the variante-code of an existing-code:

select code,dbo.VarCode(code,0),dbo.VarCode(code,1) from stammvpm where id=22936

code ...

Sorry - I've been editing my previous post and was distracted while doing so, so it all took longer than expected and that has brought the discussion a bit out...

Thanks, I fixed the header, but it didn't help with the syntax-err.

As far as the print-prob is concerned, I finally found the problem: wrong sequence of events - @code was...

Ok, we're dealing with SKU-Code that are supposed to start with letter L followed by n digits (main-code) and then a '.' and a two-digit code (variant).

Examples: "S004711.00" or "S004712.07"

Illegal:...

Thanks for looking at it so quickly 🙂 I have wrapped the last long statement.

Oh no, this is embarrassing - it works! I had some "GO"-commands in there and had...

Yeah, it works 🙂

Thanks guy, as hard as I tried, I didn't figure that one out and doubt I would have found it. Hope I learned this now 🙂

Many thanks!