StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONested Trigger problem
primarykey
Id
6885075
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-30T18:16:49.303
FavoriteCount
0
LastActivityDate
2011-07-30T18:29:47.920
LastEditDate
2011-07-30T18:29:47.920
LastEditorUserId
756166
OwnerUserId
756166
ParentId
0
PostTypeId
1
Score
0
ViewCount
129
LastEditorDisplayName
text
Body
I am working on a solution where sql triggers are called in a nested fashion, I will explain the problem later on let me first introduce you the tables first. <ol> <li>BillDetails</li> <li>SubProductAtLocation</li> </ol> Yes, this is an erp designed for a retail store, Bill details table consist of rows bill Items billDetails <ol> <li>RowID</li> <li>BillID</li> <li>SubProductID</li> <li>MRP</li> <li>quantity</li> <li>Tax</li> <li>Discount</li> </ol> subproductLocation <ol> <li>RowID</li> <li>SubproductID</li> <li>LocationID</li> <li>Quantity</li> <li>ProductID</li> </ol> <code>**now**</code> There is a trigger which runs after BillDetails Insertion, whose function is to deduct quantity from SubProductAtLocation, further more there are triggers after insert, update in subproductAtLocation, which writes Auditing log. <code>**Problem**</code> I would not want subproductAtLocation triggers to run if its called due to update done by billdetails trigger, usually I can disable triggers temporarily or can <code>sp_configure 'nested triggers' n</code> but can not do this as sql server is shared and doing this is nor feasible neither permitted. <pre><code>**Possible Solution** </code></pre> If I can store a flag value some where which is check by subproductatLocation Triggers and can rollback transaction if flag is set. This flag can be cleared in last line of BillDetails Trigger. Kindly pardon my poor knowledge Thanks
Tags
<sql><tsql>
Title
Nested Trigger problem
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSteve.Naash
UserOwnerUserId
1. USSteve.Naash
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.