Sean Lange (2/19/2016)

---

LittleTony (2/19/2016)

---

Sean Lange (2/19/2016)

---

You have a couple of logical concerns in your trigger. The first one is the one that is causing you issues. Why do you need...

Sean Lange (2/19/2016)

---

You have a couple of logical concerns in your trigger. The first one is the one that is causing you issues. Why do you need to create the...

GilaMonster (2/19/2016)

---

The cause is detailed in the error message.

"An explicit value for identity column in table dbo.N8_SPEC_STAT_DELETED can only be specified when a column list is used and IDENTITY_INSERT is...

Here other example data and how i solved it (in different way because wasn't able to have GrandTotal and SubTotal as i wanted)

declare @TestData table(

[Par_Id]...