Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bigsqldude
Starting Member
3 Posts |
 Posted - 2012-11-14 : 08:34:02
|
| Hi All,I have a Stored Procedure which is triggered to import/process a bunch of data from an import table. Within the SP is a UPDATE statement which it appears to not get triggered, however all the other statements within the stored procedure run fine.At the moment if I want this UPDATE statement to run, I have to open the stored procedure within the SQL Server Management tool highlight the UPDATE statement and execute it. All checks show that the UPDATE statement has done what I expected it to do.Any ideas why this could be happening?PS. This relates to SQL Server 2008 Enterprise Edition. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-11-14 : 08:39:24
|
| You'd have to show the stored procedure in order to get some help here...probably there is some kind of logic in the procedure that prevents it from running.- LumbagoMy blog-> http://thefirstsql.com |
 |
|
|
bigsqldude
Starting Member
3 Posts |
Posted - 2012-11-14 : 08:46:42
|
quote:
Originally posted by Lumbago
You'd have to show the stored procedure in order to get some help here...probably there is some kind of logic in the procedure that prevents it from running.- LumbagoMy blog-> http://thefirstsql.com
Here is the UPDATE code: -- Errors UPDATE Feed SET Feed.RowsRejected = e.Errors FROM (SELECT FeedId, SUM(num) Errors FROM (SELECT FeedId, ErrorDuplicate + CASE WHEN ErrorFormat = 1 OR ErrorQuery = 1 THEN 1 ELSE 0 END num FROM ImportErrorSubscriberNumbers) e GROUP BY FeedId) e WHERE e.FeedId = Feed.Id |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-14 : 09:13:14
|
| Possibly some type of flow control statement within the stored procedure that causes the update statement to be bypassed. |
|
|
|
bigsqldude
Starting Member
3 Posts |
Posted - 2012-11-14 : 10:20:49
|
quote:
Originally posted by bigsqldude
quote:
Originally posted by Lumbago
You'd have to show the stored procedure in order to get some help here...probably there is some kind of logic in the procedure that prevents it from running.- LumbagoMy blog-> http://thefirstsql.com
Here is the UPDATE code: -- Errors UPDATE Feed SET Feed.RowsRejected = e.Errors FROM (SELECT FeedId, SUM(num) Errors FROM (SELECT FeedId, ErrorDuplicate + CASE WHEN ErrorFormat = 1 OR ErrorQuery = 1 THEN 1 ELSE 0 END num FROM ImportErrorSubscriberNumbers) e GROUP BY FeedId) e WHERE e.FeedId = Feed.Id
Do I need to paste the whole procedure do you think ? I am reluctant to share it all. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-14 : 10:49:08
|
| You don't have to; you can debug it yourself as follows: Insert a few print statements at points from the beginning of the stored proc to just before the update statement is called. Then run the stored proc from an SSMS window and see which of those get printed. I suspect the one just before the update statement won't get printed. |
|
|
|
|
|
|
UPDATE Not Triggered in Stored Procedure