Skip to content
Advertisement

Updating a Table after some values are inserted into it in SQL Server 2008

I am trying to write a stored procedure in SQL Server 2008 which updates a table after some values are inserted into the table.

My stored procedure takes the values from a DMV and stores them in a table. In the same procedure after insert query, I have written an update query for the same table.

Insert results are populated fine, but the results of updates are getting lost.

But when I try to do only inserts in the stored procedure and I execute the update query manually everything is fine.

Why it is happening like this?

Advertisement

Answer

there should not be a problem in this.

below code working as expected.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement