As long as there are records to update by both update statements, it seems to work fine. However, if the conditions exists where there are no records to update in the first update statement, but there are some to update with the second update statement, it doesn't work. No records get updated in this situation. Its like since it cannot find any records to update with the first statement, it quits and never gets to the second update statement.
USE [database name] GO ALTER PROCEDURE [dbo].[stored procedure name] as BEGIN UPDATE ... SET ... FROM ... LEFT OUTER JOIN ... ON ... WHERE ... UPDATE ... SET ... FROM ... INNER JOIN ... ON ... WHERE ... END
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.